/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50627
 Source Host           : localhost
 Source Database       : ooseova

 Target Server Version : 50627
 File Encoding         : utf-8

 Date: 07/15/2017 16:58:59 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `eova_button`
-- ----------------------------
DROP TABLE IF EXISTS `eova_button`;
CREATE TABLE `eova_button` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_code` varchar(255) NOT NULL COMMENT '菜单Code',
  `name` varchar(255) NOT NULL COMMENT '按钮名称',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `ui` varchar(255) DEFAULT NULL COMMENT '按钮UI路径',
  `bs` varchar(500) DEFAULT NULL COMMENT '按钮BS路径',
  `order_num` int(11) DEFAULT '0' COMMENT '排序号',
  `group_num` int(11) DEFAULT '0' COMMENT '分组号',
  `is_base` tinyint(1) DEFAULT '0' COMMENT '是否基础功能',
  `is_hide` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1201 DEFAULT CHARSET=utf8 COMMENT='EOVA操作按钮';

-- ----------------------------
--  Records of `eova_button`
-- ----------------------------
BEGIN;
INSERT INTO `eova_button` VALUES ('1', 'eova_menu', '查询', null, 'query', null, '0', '0', '1', '0'), ('2', 'eova_menu', '新增', null, '/eova/template/singletree/btn/add.html', null, '1', '0', '1', '1'), ('3', 'eova_menu', '修改', null, '/eova/template/singletree/btn/update.html', null, '2', '0', '1', '0'), ('4', 'eova_menu', '删除', null, '/eova/template/singletree/btn/delete.html', null, '3', '0', '1', '0'), ('5', 'eova_menu', '查看', null, '/eova/template/singletree/btn/detail.html', null, '4', '0', '1', '1'), ('6', 'eova_menu', '隐藏', null, '/eova/template/singletree/btn/hide.html', null, '3', '0', '1', '0'), ('7', 'eova_menu', '导出菜单脚本', 'eova-icon387', '/eova/menu/btn/export.html', null, '12', '0', '0', '0'), ('8', 'eova_menu', '基本功能设置', 'eova-icon297', '/eova/menu/btn/fun.html', null, '11', '0', '0', '0'), ('9', 'eova_menu', '新增功能', 'eova-icon724', '/eova/menu/btn/add.html', null, '0', '0', '0', '0'), ('20', 'eova_object', '查询', null, 'query', null, '0', '0', '1', '0'), ('21', 'eova_object', '新增', null, '/eova/template/masterslave/btn1/add.html', null, '1', '0', '1', '1'), ('22', 'eova_object', '修改', null, '/eova/template/masterslave/btn1/update.html', null, '2', '0', '1', '0'), ('23', 'eova_object', '删除', null, '/eova/template/masterslave/btn1/delete.html', null, '3', '0', '1', '0'), ('24', 'eova_object', '查看', null, '/eova/template/masterslave/btn1/detail.html', null, '4', '0', '1', '1'), ('25', 'eova_object', '字段新增', null, '/eova/template/masterslave/btn2/add.html', null, '0', '1', '1', '0'), ('26', 'eova_object', '字段修改', null, '/eova/template/masterslave/btn2/update.html', null, '1', '1', '1', '0'), ('27', 'eova_object', '字段删除', null, '/eova/template/masterslave/btn2/delete.html', null, '2', '1', '1', '0'), ('28', 'eova_object', '导出元数据脚本', 'eova-icon387', '/eova/meta/btn/export.html', null, '11', '0', '0', '0'), ('29', 'eova_object', '导入元数据', 'eova-icon387', '/eova/meta/btn/import.html', null, '10', '0', '0', '0'), ('30', 'eova_object', '覆盖同步', 'eova-icon391', '/eova/meta/btn/override.html', null, '12', '0', '0', '0'), ('31', 'eova_object', '增量同步', 'eova-icon391', '/eova/meta/btn/syncnew.html', null, '13', '0', '0', '0'), ('32', 'eova_object', '复制元数据', 'eova-icon382', '/eova/meta/btn/copy.html', null, '14', '0', '0', '0'), ('40', 'eova_button', '查询', null, 'query', null, '0', '0', '1', '0'), ('41', 'eova_button', '新增', null, '/eova/template/treetogrid/btn/add.html', null, '1', '0', '1', '0'), ('42', 'eova_button', '修改', null, '/eova/template/treetogrid/btn/update.html', null, '2', '0', '1', '0'), ('43', 'eova_button', '删除', null, '/eova/template/treetogrid/btn/delete.html', null, '3', '0', '1', '0'), ('44', 'eova_button', '查看', null, '/eova/template/treetogrid/btn/detail.html', null, '4', '0', '1', '0'), ('45', 'eova_button', '导出按钮脚本', 'eova-icon387', '/eova/button/btn/export.html', null, '7', '0', '0', '0'), ('80', 'eova_task', '查询', null, 'query', null, '0', '0', '1', '0'), ('81', 'eova_task', '新增', null, '/eova/template/single/btn/add.html', null, '1', '0', '1', '0'), ('82', 'eova_task', '修改', null, '/eova/template/single/btn/update.html', null, '2', '0', '1', '0'), ('83', 'eova_task', '删除', null, '/eova/template/single/btn/delete.html', null, '3', '0', '1', '0'), ('84', 'eova_task', '查看', null, '/eova/template/single/btn/detail.html', null, '4', '0', '1', '0'), ('85', 'eova_task', '导入', null, '/eova/template/single/btn/import.html', null, '5', '0', '1', '1'), ('86', 'eova_task', '启动任务', 'eova-icon288', '/eova/task/btn/start.html', null, '10', '0', '0', '0'), ('87', 'eova_task', '暂停任务', 'eova-icon287', '/eova/task/btn/stop.html', null, '11', '0', '0', '0'), ('88', 'eova_task', '立即运行一次', 'eova-icon290', '/eova/task/btn/trigger.html', null, '12', '0', '0', '0'), ('90', 'eova_code', '查询', null, 'query', null, '0', '0', '1', '0'), ('100', 'sys_log', '查询', null, 'query', '/single_grid/list/sys_log;/grid/query/eova_log_code*', '0', '0', '1', '0'), ('101', 'sys_log', '新增', null, '/eova/template/single/btn/add.html', '/form/add/eova_log_code*;/form/doAdd/eova_log_code', '1', '0', '1', '1'), ('102', 'sys_log', '修改', null, '/eova/template/single/btn/update.html', '/form/update/eova_log_code*;/form/doUpdate/eova_log_code', '2', '0', '1', '1'), ('103', 'sys_log', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/eova_log_code', '3', '0', '1', '1'), ('104', 'sys_log', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/eova_log_code*', '4', '0', '1', '1'), ('105', 'sys_log', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/sys_log;/single_grid/doImportXls/sys_log', '5', '0', '1', '1'), ('110', 'sys_auth_role', '查询', null, 'query', '/single_grid/list/sys_auth_role;/grid/query/eova_role_code*', '0', '0', '1', '0'), ('111', 'sys_auth_role', '新增', null, '/eova/template/single/btn/add.html', '/form/add/eova_role_code*;/form/doAdd/eova_role_code', '1', '0', '1', '0'), ('112', 'sys_auth_role', '修改', null, '/eova/template/single/btn/update.html', '/form/update/eova_role_code*;/form/doUpdate/eova_role_code', '2', '0', '1', '0'), ('113', 'sys_auth_role', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/eova_role_code', '3', '0', '1', '0'), ('114', 'sys_auth_role', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/eova_role_code*', '4', '0', '1', '1'), ('115', 'sys_auth_role', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/sys_auth_role;/single_grid/doImportXls/sys_auth_role', '5', '0', '1', '1'), ('116', 'sys_auth_role', '权限分配', 'eova-icon523', '/eova/auth/btn/roleChoose.html', '/auth/toRoleChoose/*;/auth/getFunJson;/auth/getRoleFunJson/*;/auth/roleChoose/*', '10', '0', '0', '0'), ('121', 'sys_auth_users', '查询', null, 'query', '/master_slave_grid/list/sys_auth_users;/grid/query/eova_user_code*;/grid/query/user_info_code*', '0', '0', '1', '0'), ('122', 'sys_auth_users', '新增', null, '/eova/template/masterslave/btn1/add.html', '/form/add/eova_user_code*;/form/doAdd/eova_user_code', '1', '0', '1', '0'), ('123', 'sys_auth_users', '修改', null, '/eova/template/masterslave/btn1/update.html', '/form/update/eova_user_code*;/form/doUpdate/eova_user_code', '2', '0', '1', '0'), ('124', 'sys_auth_users', '删除', null, '/eova/template/masterslave/btn1/delete.html', '/grid/delete/eova_user_code', '3', '0', '1', '0'), ('125', 'sys_auth_users', '查看', null, '/eova/template/masterslave/btn1/detail.html', '/form/detail/eova_user_code*', '4', '0', '1', '1'), ('126', 'sys_auth_users', '用户详细信息新增', null, '/eova/template/masterslave/btn2/add.html', '/form/add/user_info_code*;/form/doAdd/user_info_code', '0', '1', '1', '1'), ('127', 'sys_auth_users', '用户详细信息修改', null, '/eova/template/masterslave/btn2/update.html', '/form/update/user_info_code*;/form/doUpdate/user_info_code', '1', '1', '1', '0'), ('128', 'sys_auth_users', '用户详细信息删除', null, '/eova/template/masterslave/btn2/delete.html', '/grid/delete/user_info_code', '2', '1', '1', '1'), ('129', 'sys_auth_users', '修改密码', 'eova-icon572', '/eova/user/btn/pwd.html', '/user/pwd/*', '7', '0', '0', '0'), ('1000', 'biz_product', '产品发布', 'eova-icon57', '/product/btn/release.html', '/product/release', '7', '0', '0', '0'), ('1001', 'biz_demo_users', '查询', null, 'query', '/single_grid/list/biz_demo_users;/grid/query/player_code*;/grid/export/player_code*', '0', '0', '1', '0'), ('1002', 'biz_demo_users', '新增', null, '/eova/template/single/btn/add.html', '/form/add/player_code*;/form/doAdd/player_code', '1', '0', '1', '0'), ('1003', 'biz_demo_users', '修改', null, '/eova/template/single/btn/update.html', '/form/update/player_code*;/form/doUpdate/player_code', '2', '0', '1', '0'), ('1004', 'biz_demo_users', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/player_code', '3', '0', '1', '0'), ('1005', 'biz_demo_users', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/player_code*', '4', '0', '1', '0'), ('1006', 'biz_demo_users', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_users;/single_grid/doImportXls/biz_demo_users', '5', '0', '1', '0'), ('1007', 'biz_demo_users', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/player_code', '6', '0', '1', '1'), ('1008', 'biz_demo_userscell', '查询', null, 'query', '/single_grid/list/biz_demo_userscell;/grid/query/celledit_users_code*;/grid/export/celledit_users_code*', '0', '0', '1', '0'), ('1009', 'biz_demo_userscell', '新增', null, '/eova/template/single/btn/add.html', '/form/add/celledit_users_code*;/form/doAdd/celledit_users_code', '1', '0', '1', '0'), ('1010', 'biz_demo_userscell', '修改', null, '/eova/template/single/btn/update.html', '/form/update/celledit_users_code*;/form/doUpdate/celledit_users_code', '2', '0', '1', '0'), ('1011', 'biz_demo_userscell', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/celledit_users_code', '3', '0', '1', '0'), ('1012', 'biz_demo_userscell', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/celledit_users_code*', '4', '0', '1', '0'), ('1013', 'biz_demo_userscell', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_userscell;/single_grid/doImportXls/biz_demo_userscell', '5', '0', '1', '0'), ('1014', 'biz_demo_userscell', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/celledit_users_code', '6', '0', '1', '1'), ('1015', 'biz_demo_import', '查询', null, 'query', '/single_grid/list/biz_demo_import;/grid/query/player_code*;/grid/export/player_code*', '0', '0', '1', '0'), ('1016', 'biz_demo_import', '新增', null, '/eova/template/single/btn/add.html', '/form/add/player_code*;/form/doAdd/player_code', '1', '0', '1', '0'), ('1017', 'biz_demo_import', '修改', null, '/eova/template/single/btn/update.html', '/form/update/player_code*;/form/doUpdate/player_code', '2', '0', '1', '0'), ('1018', 'biz_demo_import', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/player_code', '3', '0', '1', '0'), ('1019', 'biz_demo_import', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/player_code*', '4', '0', '1', '0'), ('1020', 'biz_demo_import', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_import;/single_grid/doImportXls/biz_demo_import', '5', '0', '1', '0'), ('1021', 'biz_demo_import', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/player_code', '6', '0', '1', '1'), ('1022', 'biz_users_exp', '查询', null, 'query', '/single_grid/list/biz_users_exp;/grid/query/users_exp_code*;/grid/export/users_exp_code*', '0', '0', '1', '0'), ('1023', 'biz_users_exp', '新增', null, '/eova/template/single/btn/add.html', '/form/add/users_exp_code*;/form/doAdd/users_exp_code', '1', '0', '1', '0'), ('1024', 'biz_users_exp', '修改', null, '/eova/template/single/btn/update.html', '/form/update/users_exp_code*;/form/doUpdate/users_exp_code', '2', '0', '1', '0'), ('1025', 'biz_users_exp', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/users_exp_code', '3', '0', '1', '0'), ('1026', 'biz_users_exp', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/users_exp_code*', '4', '0', '1', '0'), ('1027', 'biz_users_exp', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_users_exp;/single_grid/doImportXls/biz_users_exp', '5', '0', '1', '0'), ('1028', 'biz_users_exp', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/users_exp_code', '6', '0', '1', '1'), ('1029', 'biz_hotelzz', '查询', null, 'query', '/master_slave_grid/list/biz_hotelzz;/grid/query/hotel*;/grid/export/hotel*;/grid/query/hotel_bed*;/grid/export/hotel_bed*;/grid/query/hotel_stock*;/grid/export/hotel_stock*', '0', '0', '1', '0'), ('1030', 'biz_hotelzz', '新增', null, '/eova/template/masterslave/btn1/add.html', '/form/add/hotel*;/form/doAdd/hotel', '1', '0', '1', '0'), ('1031', 'biz_hotelzz', '修改', null, '/eova/template/masterslave/btn1/update.html', '/form/update/hotel*;/form/doUpdate/hotel', '2', '0', '1', '0'), ('1032', 'biz_hotelzz', '删除', null, '/eova/template/masterslave/btn1/delete.html', '/grid/delete/hotel', '3', '0', '1', '0'), ('1033', 'biz_hotelzz', '查看', null, '/eova/template/masterslave/btn1/detail.html', '/form/detail/hotel*', '4', '0', '1', '0'), ('1034', 'biz_hotelzz', '床位新增', null, '/eova/template/masterslave/btn2/add.html', '/form/add/hotel_bed*;/form/doAdd/hotel_bed', '0', '1', '1', '0'), ('1035', 'biz_hotelzz', '床位修改', null, '/eova/template/masterslave/btn2/update.html', '/form/update/hotel_bed*;/form/doUpdate/hotel_bed', '1', '1', '1', '0'), ('1036', 'biz_hotelzz', '床位删除', null, '/eova/template/masterslave/btn2/delete.html', '/grid/delete/hotel_bed', '2', '1', '1', '0'), ('1037', 'biz_hotelzz', '床位查看', null, '/eova/template/masterslave/btn2/detail.html', '/form/detail/hotel_bed*', '3', '1', '1', '0'), ('1038', 'biz_hotelzz', '存货新增', null, '/eova/template/masterslave/btn2/add.html', '/form/add/hotel_stock*;/form/doAdd/hotel_stock', '0', '2', '1', '0'), ('1039', 'biz_hotelzz', '存货修改', null, '/eova/template/masterslave/btn2/update.html', '/form/update/hotel_stock*;/form/doUpdate/hotel_stock', '1', '2', '1', '0'), ('1040', 'biz_hotelzz', '存货删除', null, '/eova/template/masterslave/btn2/delete.html', '/grid/delete/hotel_stock', '2', '2', '1', '0'), ('1041', 'biz_hotelzz', '存货查看', null, '/eova/template/masterslave/btn2/detail.html', '/form/detail/hotel_stock*', '3', '2', '1', '0'), ('1042', 'biz_4j_test1', '查询', null, 'query', '/single_grid/list/biz_4j_test1;/grid/query/player_code*;/grid/export/player_code*', '0', '0', '1', '0'), ('1043', 'biz_4j_test1', '新增', null, '/eova/template/single/btn/add.html', '/form/add/player_code*;/form/doAdd/player_code', '1', '0', '1', '0'), ('1044', 'biz_4j_test1', '修改', null, '/eova/template/single/btn/update.html', '/form/update/player_code*;/form/doUpdate/player_code', '2', '0', '1', '0'), ('1045', 'biz_4j_test1', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/player_code', '3', '0', '1', '0'), ('1046', 'biz_4j_test1', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/player_code*', '4', '0', '1', '0'), ('1047', 'biz_4j_test1', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_4j_test1;/single_grid/doImportXls/biz_4j_test1', '5', '0', '1', '0'), ('1048', 'biz_4j_test1', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/player_code', '6', '0', '1', '1'), ('1049', 'biz_data_login', '查询', null, 'query', '/single_chart/list/biz_data_login;/grid/query/data_login*;/grid/export/data_login*', '0', '0', '1', '0'), ('1050', 'biz_data_login', '新增', null, '/eova/template/single/btn/add.html', '/form/add/data_login*;/form/doAdd/data_login', '1', '0', '1', '0'), ('1051', 'biz_data_login', '修改', null, '/eova/template/single/btn/update.html', '/form/update/data_login*;/form/doUpdate/data_login', '2', '0', '1', '0'), ('1052', 'biz_data_login', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/data_login', '3', '0', '1', '0'), ('1053', 'biz_data_login', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/data_login*', '4', '0', '1', '0'), ('1054', 'biz_data_login', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_data_login;/single_grid/doImportXls/biz_data_login', '5', '0', '1', '0'), ('1055', 'biz_data_login', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/data_login', '6', '0', '1', '1'), ('1056', 'biz_demo_eova_all', '查询', null, 'query', '/single_grid/list/biz_demo_eova_all;/grid/query/test_info*;/grid/export/test_info*', '0', '0', '1', '0'), ('1057', 'biz_demo_eova_all', '新增', null, '/eova/template/single/btn/add.html', '/form/add/test_info*;/form/doAdd/test_info', '1', '0', '1', '0'), ('1058', 'biz_demo_eova_all', '修改', null, '/eova/template/single/btn/update.html', '/form/update/test_info*;/form/doUpdate/test_info', '2', '0', '1', '0'), ('1059', 'biz_demo_eova_all', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/test_info', '3', '0', '1', '0'), ('1060', 'biz_demo_eova_all', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/test_info*', '4', '0', '1', '0'), ('1061', 'biz_demo_eova_all', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_eova_all;/single_grid/doImportXls/biz_demo_eova_all', '5', '0', '1', '0'), ('1062', 'biz_demo_eova_all', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/test_info', '6', '0', '1', '1'), ('1063', 'biz_demo_links', '查询', null, 'query', '/single_grid/list/biz_demo_links;/grid/query/links*;/grid/export/links*', '0', '0', '1', '0'), ('1064', 'biz_demo_links', '新增', null, '/eova/template/single/btn/add.html', '/form/add/links*;/form/doAdd/links', '1', '0', '1', '0'), ('1065', 'biz_demo_links', '修改', null, '/eova/template/single/btn/update.html', '/form/update/links*;/form/doUpdate/links', '2', '0', '1', '0'), ('1066', 'biz_demo_links', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/links', '3', '0', '1', '0'), ('1067', 'biz_demo_links', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/links*', '4', '0', '1', '0'), ('1068', 'biz_demo_links', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_links;/single_grid/doImportXls/biz_demo_links', '5', '0', '1', '0'), ('1069', 'biz_demo_links', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/links', '6', '0', '1', '1'), ('1070', 'biz_demo_money', '查询', null, 'query', '/single_chart/list/biz_demo_money;/grid/query/data_money*;/grid/export/data_money*', '0', '0', '1', '0'), ('1071', 'biz_demo_money', '新增', null, '/eova/template/single/btn/add.html', '/form/add/data_money*;/form/doAdd/data_money', '1', '0', '1', '0'), ('1072', 'biz_demo_money', '修改', null, '/eova/template/single/btn/update.html', '/form/update/data_money*;/form/doUpdate/data_money', '2', '0', '1', '0'), ('1073', 'biz_demo_money', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/data_money', '3', '0', '1', '0'), ('1074', 'biz_demo_money', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/data_money*', '4', '0', '1', '0'), ('1075', 'biz_demo_money', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_money;/single_grid/doImportXls/biz_demo_money', '5', '0', '1', '0'), ('1076', 'biz_demo_money', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/data_money', '6', '0', '1', '1'), ('1077', 'biz_demo_views_orders', '查询', null, 'query', '/single_grid/list/biz_demo_views_orders;/grid/query/v_orders*;/grid/export/v_orders*', '0', '0', '1', '0'), ('1078', 'biz_demo_views_orders', '新增', null, '/eova/template/single/btn/add.html', '/form/add/v_orders*;/form/doAdd/v_orders', '1', '0', '1', '0'), ('1079', 'biz_demo_views_orders', '修改', null, '/eova/template/single/btn/update.html', '/form/update/v_orders*;/form/doUpdate/v_orders', '2', '0', '1', '0'), ('1080', 'biz_demo_views_orders', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/v_orders', '3', '0', '1', '0'), ('1081', 'biz_demo_views_orders', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/v_orders*', '4', '0', '1', '0'), ('1082', 'biz_demo_views_orders', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_views_orders;/single_grid/doImportXls/biz_demo_views_orders', '5', '0', '1', '0'), ('1083', 'biz_demo_views_orders', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/v_orders', '6', '0', '1', '1'), ('1084', 'biz_demo_views_users', '查询', null, 'query', '/single_grid/list/biz_demo_views_users;/grid/query/v_users*;/grid/export/v_users*', '0', '0', '1', '0'), ('1085', 'biz_demo_views_users', '新增', null, '/eova/template/single/btn/add.html', '/form/add/v_users*;/form/doAdd/v_users', '1', '0', '1', '0'), ('1086', 'biz_demo_views_users', '修改', null, '/eova/template/single/btn/update.html', '/form/update/v_users*;/form/doUpdate/v_users', '2', '0', '1', '0'), ('1087', 'biz_demo_views_users', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/v_users', '3', '0', '1', '0'), ('1088', 'biz_demo_views_users', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/v_users*', '4', '0', '1', '0'), ('1089', 'biz_demo_views_users', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_views_users;/single_grid/doImportXls/biz_demo_views_users', '5', '0', '1', '0'), ('1090', 'biz_demo_views_users', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/v_users', '6', '0', '1', '1'), ('1091', 'biz_demo_area', '查询', null, 'query', '/single_tree/list/biz_demo_area;/grid/query/area*;/grid/export/area*;/treegrid/query/*', '0', '0', '1', '0'), ('1092', 'biz_demo_area', '新增', null, '/eova/template/singletree/btn/add.html', '/form/add/area*;/form/doAdd/area', '1', '0', '1', '0'), ('1093', 'biz_demo_area', '修改', null, '/eova/template/singletree/btn/update.html', '/form/update/area*;/form/doUpdate/area', '2', '0', '1', '0'), ('1094', 'biz_demo_area', '删除', null, '/eova/template/singletree/btn/delete.html', '/grid/delete/area', '3', '0', '1', '0'), ('1095', 'biz_demo_area', '查看', null, '/eova/template/singletree/btn/detail.html', '/form/detail/area*', '4', '0', '1', '0'), ('1096', 'biz_demo_area', '隐藏', null, '/eova/template/singletree/btn/hide.html', '/grid/hide/area', '5', '0', '1', '1'), ('1097', 'biz_demo_tree_code', '查询', null, 'query', '/single_tree/list/biz_demo_tree_code;/grid/query/area_city*;/grid/export/area_city*;/treegrid/query/*', '0', '0', '1', '0'), ('1098', 'biz_demo_tree_code', '新增', null, '/eova/template/singletree/btn/add.html', '/form/add/area_city*;/form/doAdd/area_city', '1', '0', '1', '0'), ('1099', 'biz_demo_tree_code', '修改', null, '/eova/template/singletree/btn/update.html', '/form/update/area_city*;/form/doUpdate/area_city', '2', '0', '1', '0'), ('1100', 'biz_demo_tree_code', '删除', null, '/eova/template/singletree/btn/delete.html', '/grid/delete/area_city', '3', '0', '1', '0'), ('1101', 'biz_demo_tree_code', '查看', null, '/eova/template/singletree/btn/detail.html', '/form/detail/area_city*', '4', '0', '1', '0'), ('1102', 'biz_demo_tree_code', '隐藏', null, '/eova/template/singletree/btn/hide.html', '/grid/hide/area_city', '5', '0', '1', '1'), ('1103', 'biz_demo_sale', '查询', null, 'query', '/tree_grid/list/biz_demo_sale;/grid/query/sale_data*;/grid/export/sale_data*;/tree/query/area_city*', '0', '0', '1', '0'), ('1104', 'biz_demo_sale', '新增', null, '/eova/template/treetogrid/btn/add.html', '/form/add/sale_data*;/form/doAdd/sale_data', '1', '0', '1', '0'), ('1105', 'biz_demo_sale', '修改', null, '/eova/template/treetogrid/btn/update.html', '/form/update/sale_data*;/form/doUpdate/sale_data', '2', '0', '1', '0'), ('1106', 'biz_demo_sale', '删除', null, '/eova/template/treetogrid/btn/delete.html', '/grid/delete/sale_data', '3', '0', '1', '0'), ('1107', 'biz_demo_sale', '查看', null, '/eova/template/treetogrid/btn/detail.html', '/form/detail/sale_data*', '4', '0', '1', '0'), ('1108', 'biz_demo_hotel', '查询', null, 'query', '/single_grid/list/biz_demo_hotel;/grid/query/hotel*;/grid/export/hotel*', '0', '0', '1', '0'), ('1109', 'biz_demo_hotel', '新增', null, '/eova/template/single/btn/add.html', '/form/add/hotel*;/form/doAdd/hotel', '1', '0', '1', '0'), ('1110', 'biz_demo_hotel', '修改', null, '/eova/template/single/btn/update.html', '/form/update/hotel*;/form/doUpdate/hotel', '2', '0', '1', '0'), ('1111', 'biz_demo_hotel', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/hotel', '3', '0', '1', '0'), ('1112', 'biz_demo_hotel', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/hotel*', '4', '0', '1', '0'), ('1113', 'biz_demo_hotel', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_hotel;/single_grid/doImportXls/biz_demo_hotel', '5', '0', '1', '0'), ('1114', 'biz_demo_hotel', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/hotel', '6', '0', '1', '1'), ('1115', 'biz_demo_hotel_stock', '查询', null, 'query', '/single_grid/list/biz_demo_hotel_stock;/grid/query/hotel_stock*;/grid/export/hotel_stock*', '0', '0', '1', '0'), ('1116', 'biz_demo_hotel_stock', '新增', null, '/eova/template/single/btn/add.html', '/form/add/hotel_stock*;/form/doAdd/hotel_stock', '1', '0', '1', '0'), ('1117', 'biz_demo_hotel_stock', '修改', null, '/eova/template/single/btn/update.html', '/form/update/hotel_stock*;/form/doUpdate/hotel_stock', '2', '0', '1', '0'), ('1118', 'biz_demo_hotel_stock', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/hotel_stock', '3', '0', '1', '0'), ('1119', 'biz_demo_hotel_stock', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/hotel_stock*', '4', '0', '1', '0'), ('1120', 'biz_demo_hotel_stock', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_demo_hotel_stock;/single_grid/doImportXls/biz_demo_hotel_stock', '5', '0', '1', '0'), ('1121', 'biz_demo_hotel_stock', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/hotel_stock', '6', '0', '1', '1'), ('1122', 'biz_product', '查询', null, 'query', '/single_grid/list/biz_product;/grid/query/product*;/grid/export/product*', '0', '0', '1', '0'), ('1123', 'biz_product', '新增', null, '/eova/template/single/btn/add.html', '/form/add/product*;/form/doAdd/product', '1', '0', '1', '0'), ('1124', 'biz_product', '修改', null, '/eova/template/single/btn/update.html', '/form/update/product*;/form/doUpdate/product', '2', '0', '1', '0'), ('1125', 'biz_product', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/product', '3', '0', '1', '0'), ('1126', 'biz_product', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/product*', '4', '0', '1', '0'), ('1127', 'biz_product', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/biz_product;/single_grid/doImportXls/biz_product', '5', '0', '1', '0'), ('1128', 'biz_product', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/product', '6', '0', '1', '1'), ('1129', 'biz_demo_xls', '查询', null, 'query', '/diy/list/biz_demo_xls;/grid/query/null*;/grid/export/null*', '0', '0', '1', '0'), ('1130', 'druid', '查询', null, 'query', '/diy/list/druid;/grid/query/null*;/grid/export/null*', '0', '0', '1', '0'), ('1131', 'wxlogin', '查询', null, 'query', '/single_grid/list/wxlogin;/grid/query/wxadmin*;/grid/export/wxadmin*', '0', '0', '1', '0'), ('1132', 'wxlogin', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxadmin*;/form/doAdd/wxadmin', '1', '0', '1', '0'), ('1133', 'wxlogin', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxadmin*;/form/doUpdate/wxadmin', '2', '0', '1', '0'), ('1134', 'wxlogin', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxadmin', '3', '0', '1', '0'), ('1135', 'wxlogin', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxadmin*', '4', '0', '1', '0'), ('1136', 'wxlogin', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/wxlogin;/single_grid/doImportXls/wxlogin', '5', '0', '1', '0'), ('1137', 'wxlogin', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxadmin', '6', '0', '1', '1'), ('1138', 'wxconfig', '查询', null, 'query', '/single_grid/list/wxconfig;/grid/query/wxconfig*;/grid/export/wxconfig*', '0', '0', '1', '0'), ('1139', 'wxconfig', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxconfig*;/form/doAdd/wxconfig', '1', '0', '1', '0'), ('1140', 'wxconfig', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxconfig*;/form/doUpdate/wxconfig', '2', '0', '1', '0'), ('1141', 'wxconfig', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxconfig', '3', '0', '1', '0'), ('1142', 'wxconfig', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxconfig*', '4', '0', '1', '0'), ('1143', 'wxconfig', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/wxconfig;/single_grid/doImportXls/wxconfig', '5', '0', '1', '0'), ('1144', 'wxconfig', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxconfig', '6', '0', '1', '1'), ('1145', 'eovadoc', '查询', null, 'query', '/diy/list/eovadoc;/grid/query/null*;/grid/export/null*', '0', '0', '1', '0'), ('1146', 'submsg', '查询', null, 'query', '/single_grid/list/submsg;/grid/query/wxsubmgs*;/grid/export/wxsubmgs*', '0', '0', '1', '0'), ('1147', 'submsg', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxsubmgs*;/form/doAdd/wxsubmgs', '1', '0', '1', '0'), ('1148', 'submsg', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxsubmgs*;/form/doUpdate/wxsubmgs', '2', '0', '1', '0'), ('1149', 'submsg', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxsubmgs', '3', '0', '1', '0'), ('1150', 'submsg', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxsubmgs*', '4', '0', '1', '0'), ('1151', 'submsg', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/submsg;/single_grid/doImportXls/submsg', '5', '0', '1', '0'), ('1152', 'submsg', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxsubmgs', '6', '0', '1', '1'), ('1153', 'wxmaterialmgr', '查询', null, 'query', '/single_grid/list/wxmaterialmgr;/grid/query/wxmaterial*;/grid/export/wxmaterial*', '0', '0', '1', '0'), ('1154', 'wxmaterialmgr', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxmaterial*;/form/doAdd/wxmaterial', '1', '0', '1', '0'), ('1155', 'wxmaterialmgr', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxmaterial*;/form/doUpdate/wxmaterial', '2', '0', '1', '0'), ('1156', 'wxmaterialmgr', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxmaterial', '3', '0', '1', '0'), ('1157', 'wxmaterialmgr', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxmaterial*', '4', '0', '1', '0'), ('1158', 'wxmaterialmgr', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/wxmaterialmgr;/single_grid/doImportXls/wxmaterialmgr', '5', '0', '1', '0'), ('1159', 'wxmaterialmgr', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxmaterial', '6', '0', '1', '1'), ('1160', 'messagemgr', '查询', null, 'query', '/single_grid/list/messagemgr;/grid/query/mxmessage*;/grid/export/mxmessage*', '0', '0', '1', '0'), ('1161', 'messagemgr', '新增', null, '/eova/template/single/btn/add.html', '/form/add/mxmessage*;/form/doAdd/mxmessage', '1', '0', '1', '0'), ('1162', 'messagemgr', '修改', null, '/eova/template/single/btn/update.html', '/form/update/mxmessage*;/form/doUpdate/mxmessage', '2', '0', '1', '0'), ('1163', 'messagemgr', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/mxmessage', '3', '0', '1', '0'), ('1164', 'messagemgr', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/mxmessage*', '4', '0', '1', '0'), ('1165', 'messagemgr', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/messagemgr;/single_grid/doImportXls/messagemgr', '5', '0', '1', '0'), ('1166', 'messagemgr', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/mxmessage', '6', '0', '1', '1'), ('1167', 'usermgr', '查询', null, 'query', '/single_grid/list/usermgr;/grid/query/wxuser*;/grid/export/wxuser*', '0', '0', '1', '0'), ('1168', 'usermgr', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxuser*;/form/doAdd/wxuser', '1', '0', '1', '0'), ('1169', 'usermgr', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxuser*;/form/doUpdate/wxuser', '2', '0', '1', '0'), ('1170', 'usermgr', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxuser', '3', '0', '1', '0'), ('1171', 'usermgr', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxuser*', '4', '0', '1', '0'), ('1172', 'usermgr', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/usermgr;/single_grid/doImportXls/usermgr', '5', '0', '1', '0'), ('1173', 'usermgr', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxuser', '6', '0', '1', '1'), ('1174', 'automessage', '查询', null, 'query', '/single_grid/list/automessage;/grid/query/wxkeyword*;/grid/export/wxkeyword*', '0', '0', '1', '0'), ('1175', 'automessage', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wxkeyword*;/form/doAdd/wxkeyword', '1', '0', '1', '0'), ('1176', 'automessage', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wxkeyword*;/form/doUpdate/wxkeyword', '2', '0', '1', '0'), ('1177', 'automessage', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wxkeyword', '3', '0', '1', '0'), ('1178', 'automessage', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wxkeyword*', '4', '0', '1', '0'), ('1179', 'automessage', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/automessage;/single_grid/doImportXls/automessage', '5', '0', '1', '0'), ('1180', 'automessage', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wxkeyword', '6', '0', '1', '1'), ('1181', 'menu_type', '查询', null, 'query', '/single_grid/list/menu_type;/grid/query/wx_menutype*;/grid/export/wx_menutype*', '0', '0', '1', '0'), ('1182', 'menu_type', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wx_menutype*;/form/doAdd/wx_menutype', '1', '0', '1', '0'), ('1183', 'menu_type', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wx_menutype*;/form/doUpdate/wx_menutype', '2', '0', '1', '0'), ('1184', 'menu_type', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wx_menutype', '3', '0', '1', '0'), ('1185', 'menu_type', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wx_menutype*', '4', '0', '1', '0'), ('1186', 'menu_type', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/menu_type;/single_grid/doImportXls/menu_type', '5', '0', '1', '0'), ('1187', 'menu_type', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wx_menutype', '6', '0', '1', '1'), ('1188', 'custom_menu', '查询', null, 'query', '/single_tree/list/custom_menu;/grid/query/wx_custommenu*;/grid/export/wx_custommenu*;/treegrid/query/*', '0', '0', '1', '0'), ('1189', 'custom_menu', '新增', null, '/eova/template/singletree/btn/add.html', '/form/add/wx_custommenu*;/form/doAdd/wx_custommenu', '1', '0', '1', '0'), ('1190', 'custom_menu', '修改', null, '/eova/template/singletree/btn/update.html', '/form/update/wx_custommenu*;/form/doUpdate/wx_custommenu', '2', '0', '1', '0'), ('1191', 'custom_menu', '删除', null, '/eova/template/singletree/btn/delete.html', '/grid/delete/wx_custommenu', '3', '0', '1', '0'), ('1192', 'custom_menu', '查看', null, '/eova/template/singletree/btn/detail.html', '/form/detail/wx_custommenu*', '4', '0', '1', '0'), ('1193', 'custom_menu', '隐藏', null, '/eova/template/singletree/btn/hide.html', '/grid/hide/wx_custommenu', '5', '0', '1', '1'), ('1194', 'matchrule_menu', '查询', null, 'query', '/single_grid/list/matchrule_menu;/grid/query/wx_matchrulemenu*;/grid/export/wx_matchrulemenu*', '0', '0', '1', '0'), ('1195', 'matchrule_menu', '新增', null, '/eova/template/single/btn/add.html', '/form/add/wx_matchrulemenu*;/form/doAdd/wx_matchrulemenu', '1', '0', '1', '0'), ('1196', 'matchrule_menu', '修改', null, '/eova/template/single/btn/update.html', '/form/update/wx_matchrulemenu*;/form/doUpdate/wx_matchrulemenu', '2', '0', '1', '0'), ('1197', 'matchrule_menu', '删除', null, '/eova/template/single/btn/delete.html', '/grid/delete/wx_matchrulemenu', '3', '0', '1', '0'), ('1198', 'matchrule_menu', '查看', null, '/eova/template/single/btn/detail.html', '/form/detail/wx_matchrulemenu*', '4', '0', '1', '0'), ('1199', 'matchrule_menu', '导入', null, '/eova/template/single/btn/import.html', '/single_grid/importXls/matchrule_menu;/single_grid/doImportXls/matchrule_menu', '5', '0', '1', '0'), ('1200', 'matchrule_menu', '隐藏', null, '/eova/template/single/btn/hide.html', '/grid/hide/wx_matchrulemenu', '6', '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eova_dict`
-- ----------------------------
DROP TABLE IF EXISTS `eova_dict`;
CREATE TABLE `eova_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `object` varchar(50) NOT NULL,
  `field` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='EOVA字典';

-- ----------------------------
--  Records of `eova_dict`
-- ----------------------------
BEGIN;
INSERT INTO `eova_dict` VALUES ('1', 'main', '默认', 'eova_object', 'data_source'), ('2', 'eova', 'EOVA', 'eova_object', 'data_source'), ('40', '1', '新增', 'eova_log', 'type'), ('41', '2', '修改', 'eova_log', 'type'), ('42', '3', '删除', 'eova_log', 'type'), ('70', '0', '正常', 'eova_field', 'update_status'), ('71', '10', '只读', 'eova_field', 'update_status'), ('72', '20', '隐藏', 'eova_field', 'update_status'), ('73', '50', '禁用', 'eova_field', 'update_status'), ('100', '0', '暂停', 'eova_job', 'state'), ('101', '1', '运行', 'eova_job', 'state');
COMMIT;

-- ----------------------------
--  Table structure for `eova_field`
-- ----------------------------
DROP TABLE IF EXISTS `eova_field`;
CREATE TABLE `eova_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `object_code` varchar(50) NOT NULL,
  `fieldnum` int(11) DEFAULT '0' COMMENT '表单分组序号',
  `order_num` int(4) DEFAULT '9' COMMENT '排序索引',
  `fieldset` varchar(255) DEFAULT '' COMMENT '表单分组',
  `table_name` varchar(255) DEFAULT NULL COMMENT '字段表名',
  `en` varchar(50) NOT NULL COMMENT '英文名',
  `cn` varchar(50) NOT NULL COMMENT '中文名',
  `is_auto` tinyint(1) DEFAULT '0' COMMENT '主键是否自增长',
  `type` varchar(10) DEFAULT '文本框' COMMENT '控件类型',
  `exp` varchar(800) DEFAULT NULL COMMENT '控件表达式',
  `is_query` tinyint(1) DEFAULT '0' COMMENT '是否可查询',
  `is_show` tinyint(1) DEFAULT '1' COMMENT '是否可显示',
  `is_disable` tinyint(1) DEFAULT '0' COMMENT '是否禁用',
  `is_order` tinyint(1) DEFAULT '1' COMMENT '是否可排序',
  `is_add` tinyint(1) DEFAULT '1' COMMENT '是否可新增字段(V1.6废弃)',
  `is_update` tinyint(1) DEFAULT '1' COMMENT '是否可修改字段(V1.6废弃)',
  `is_edit` tinyint(1) DEFAULT '1' COMMENT '是否可编辑字段',
  `is_required` tinyint(1) DEFAULT '1' COMMENT '是否必填',
  `is_multiple` tinyint(1) DEFAULT '0' COMMENT '是否多选项',
  `placeholder` varchar(255) DEFAULT NULL COMMENT '输入提示',
  `validator` varchar(255) DEFAULT NULL COMMENT 'UI校验表达式',
  `defaulter` varchar(255) DEFAULT NULL COMMENT '默认值表达式',
  `formatter` varchar(2000) DEFAULT NULL COMMENT '格式化器',
  `width` int(4) DEFAULT '130' COMMENT '控件宽度',
  `height` int(4) DEFAULT '20' COMMENT '控件高度',
  `config` varchar(2000) DEFAULT NULL COMMENT '拓展配置',
  `add_status` int(3) DEFAULT '0' COMMENT '状态：0=正常，10=只读，20=隐藏，50=禁用',
  `update_status` int(3) DEFAULT '0' COMMENT '状态：0=正常，10=只读，20=隐藏，50=禁用',
  `data_type` int(5) DEFAULT '12' COMMENT '数据类型',
  `data_type_name` varchar(20) DEFAULT 'VARCHAR' COMMENT '数据类型名称',
  `data_size` int(2) DEFAULT '1' COMMENT '整数位长度',
  `data_decimal` int(2) DEFAULT '0' COMMENT '小数位长度',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3394 DEFAULT CHARSET=utf8 COMMENT='EOVA元字段';

-- ----------------------------
--  Records of `eova_field`
-- ----------------------------
BEGIN;
INSERT INTO `eova_field` VALUES ('1', 'eova_meta_template', '0', '0', '', null, 'meta', 'meta', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2', 'eova_object_code', '0', '1', '基础信息', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3', 'eova_object_code', '0', '2', '基础信息', null, 'code', '编码', '0', '文本框', null, '1', '1', '0', '1', '1', '0', '0', '1', '0', null, 'eovacode', null, null, '200', '20', null, '0', '10', '12', 'VARCHAR', '100', '0'), ('4', 'eova_object_code', '0', '3', '基础信息', null, 'name', '名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '100', '0'), ('5', 'eova_object_code', '0', '4', '基础信息', null, 'view_name', '视图', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '70', '20', null, '50', '10', '12', 'VARCHAR', '255', '0'), ('6', 'eova_object_code', '0', '5', '基础信息', null, 'table_name', '数据表', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '80', '20', null, '50', '10', '12', 'VARCHAR', '255', '0'), ('7', 'eova_object_code', '0', '6', '基础信息', null, 'pk_name', '主键', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '0', '1', '0', null, null, null, null, '70', '20', null, '50', '10', '12', 'VARCHAR', '50', '0'), ('8', 'eova_object_code', '0', '7', '基础信息', null, 'data_source', '数据源', '0', '下拉框', 'select value ID,name CN from eova_dict where object = \'eova_object\' and field = \'data_source\';ds=eova', '0', '1', '0', '1', '1', '1', '0', '1', '0', null, null, 'main', null, '70', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('9', 'eova_object_code', '1', '8', '功能配置', null, 'is_single', '单选/多选', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, '1', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('10', 'eova_object_code', '1', '9', '功能配置', null, 'is_show_num', '显示行号', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, '1', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('11', 'eova_object_code', '1', '10', '功能配置', null, 'default_order', '默认排序', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', '例如：id desc (默认按ID倒序)', null, null, null, '70', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('12', 'eova_object_code', '1', '11', '功能配置', null, 'filter', '过滤条件', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', '例如：status = 1 (只显示状态为1的数据)', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('13', 'eova_object_code', '1', '13', '功能配置', null, 'diy_js', '依赖JS', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '自定义JS文件路径', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('14', 'eova_object_code', '1', '8', '功能配置', null, 'is_celledit', '行内编辑', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, '0', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('15', 'eova_object_code', '1', '12', '功能配置', null, 'biz_intercept', '业务拦截器', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', '继承：com.eova.core.meta.MetaObjectIntercept', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('16', 'eova_object_code', '1', '9', '功能配置', null, 'is_first_load', '是否初始加载', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('17', 'eova_object_code', '1', '17', '功能配置', null, 'view_sql', '视图SQL', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '100', null, '50', '10', '12', 'VARCHAR', '1000', '0'), ('18', 'eova_object_code', '1', '18', '功能配置', null, 'config', '拓展配置', '0', 'JSON框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '300', null, '0', '0', '12', 'VARCHAR', '2000', '0'), ('50', 'eova_field_code', '0', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('51', 'eova_field_code', '0', '2', '', null, 'object_code', '对象编码', '0', '查找框', 'select code 编码,name 名称 from eova_object where id > 999 order by id desc;ds=eova', '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '150', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('52', 'eova_field_code', '0', '9', '', null, 'en', '字段名', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', '数据库的字段名', null, null, null, '120', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('53', 'eova_field_code', '0', '8', '', null, 'cn', '中文名', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', '字段对应的中文描述', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('54', 'eova_field_code', '0', '24', '', null, 'is_auto', '自增长', '0', '布尔框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('55', 'eova_field_code', '0', '10', '', null, 'data_type_name', '字段类型', '0', '文本框', '', '0', '0', '0', '0', '1', '1', '0', '0', '0', null, null, null, null, '70', '20', null, '0', '10', '12', 'VARCHAR', '20', '0'), ('56', 'eova_field_code', '0', '11', '', null, 'type', '控件类型', '0', '下拉框', 'select value ID,name CN from eova_widget;ds=eova', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '文本框', null, '70', '20', null, '0', '0', '12', 'VARCHAR', '10', '0'), ('57', 'eova_field_code', '0', '6', '', null, 'order_num', '排序', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '9', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('58', 'eova_field_code', '0', '51', '', null, 'exp', '表达式', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '查找框和下拉框需需要表达式', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '800', '0'), ('59', 'eova_field_code', '0', '25', '', null, 'is_query', '快速查询', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '60', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('60', 'eova_field_code', '0', '26', '', null, 'is_show', '列表显示', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '60', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('61', 'eova_field_code', '0', '32', '', null, 'is_order', '允许排序', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '60', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('62', 'eova_field_code', '0', '28', '', null, 'is_add', '允许新增', '0', '布尔框', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '1', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('63', 'eova_field_code', '0', '29', '', null, 'is_update', '允许修改', '0', '布尔框', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '1', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('64', 'eova_field_code', '0', '31', '', null, 'is_required', '是否必填', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '60', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('65', 'eova_field_code', '0', '36', '', null, 'defaulter', '默认值', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '缺省默认值', null, null, null, '110', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('66', 'eova_field_code', '0', '20', '', null, 'width', '宽度', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '130', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('67', 'eova_field_code', '0', '21', '', null, 'height', '高度', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '20', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('68', 'eova_field_code', '0', '33', '', null, 'is_multiple', '是否有多值', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('69', 'eova_field_code', '0', '30', '', null, 'is_edit', '单元格编辑', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '75', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('70', 'eova_field_code', '0', '35', '', null, 'placeholder', '输入提示', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', 'input的placeholder属性', null, null, null, '60', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('71', 'eova_field_code', '0', '54', '', null, 'formatter', '格式化器', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '格式化的JS,参考EasyUI datagrid formatter', null, null, null, '130', '150', null, '0', '0', '12', 'VARCHAR', '2000', '0'), ('72', 'eova_field_code', '0', '53', '', null, 'validator', 'UI校验器', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', 'UI校验规则', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('73', 'eova_field_code', '0', '27', '', null, 'is_disable', '是否禁用', '0', '布尔框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '70', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('74', 'eova_field_code', '0', '23', '', null, 'update_status', '更新状态', '0', '下拉框', 'select value ID,name CN from eova_dict where object = \'eova_field\' and field = \'update_status\';ds=eova', '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '60', '20', null, '0', '0', '4', 'INT', '10', '0'), ('75', 'eova_field_code', '0', '22', '', null, 'add_status', '新增状态', '0', '下拉框', 'select value ID,name CN from eova_dict where object = \'eova_field\' and field = \'update_status\';ds=eova', '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '60', '20', null, '0', '0', '4', 'INT', '10', '0'), ('76', 'eova_field_code', '0', '7', '', null, 'fieldset', '分组名称', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '90', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('77', 'eova_field_code', '0', '5', '', null, 'fieldnum', '分组号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '70', '20', null, '0', '0', '4', 'INT', '10', '0'), ('78', 'eova_field_code', '0', '6', '', null, 'table_name', '字段表名', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '100', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('79', 'eova_field_code', '0', '999', '', null, 'config', '拓展配置', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '2000', '0'), ('80', 'eova_field_code', '0', '30', '', null, 'data_type', '数据类型', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '0', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('81', 'eova_field_code', '0', '32', '', null, 'data_size', '整数位长度', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('82', 'eova_field_code', '0', '33', '', null, 'data_decimal', '小数位长度', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('100', 'eova_menu_code', '0', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '40', '20', null, '50', '20', '4', 'INT', '10', '0'), ('101', 'eova_menu_code', '0', '4', '', null, 'code', '编码', '0', '文本框', null, '1', '1', '1', '1', '1', '0', '0', '0', '0', null, 'eovacode', null, null, '200', '20', null, '0', '10', '12', 'VARCHAR', '255', '0'), ('102', 'eova_menu_code', '0', '1', '', null, 'name', '名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '200', '20', null, '0', '0', '12', 'VARCHAR', '100', '0'), ('103', 'eova_menu_code', '0', '2', '', null, 'type', '类型', '0', '文本框', null, '0', '1', '0', '1', '1', '0', '0', '0', '0', null, null, null, null, '120', '20', null, '0', '10', '12', 'VARCHAR', '20', '0'), ('104', 'eova_menu_code', '0', '6', '', null, 'iconskip', '图标', '0', '图标框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('105', 'eova_menu_code', '0', '9', '', null, 'order_num', '序号', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', null, null, '0', null, '30', '20', null, '0', '0', '4', 'INT', '10', '0'), ('106', 'eova_menu_code', '0', '9', '', null, 'parent_id', '父节点', '0', '文本框', '', '0', '0', '0', '1', '1', '0', '0', '0', '0', null, null, '0', null, '100', '20', null, '0', '10', '4', 'INT', '10', '0'), ('107', 'eova_menu_code', '0', '16', '', null, 'is_hide', '是否隐藏', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '10', '10', '-7', 'BIT', '0', '0'), ('109', 'eova_menu_code', '0', '12', '', null, 'biz_intercept', '业务拦截器', '0', '文本域', null, '0', '0', '0', '1', '1', '1', '0', '0', '0', '继承：模版业务拦截器', null, null, null, '300', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('110', 'eova_menu_code', '0', '15', '', null, 'url', '自定义功能', '0', '文本域', null, '0', '0', '0', '1', '1', '0', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '50', '12', 'VARCHAR', '255', '0'), ('111', 'eova_menu_code', '0', '11', '', null, 'filter', '过滤条件', '0', '文本域', '', '0', '1', '0', '1', '1', '1', '1', '0', '0', '例如：status = 1 (只显示状态为1的数据)', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('112', 'eova_menu_code', '0', '13', '', null, 'diy_js', '依赖JS', '0', '文本域', '', '0', '0', '0', '1', '1', '1', '1', '0', '0', '自定义JS文件路径', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('113', 'eova_menu_code', '0', '17', '', null, 'open', '是否展开', '0', '布尔框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('114', 'eova_menu_code', '0', '18', '', null, 'config', '菜单配置JSON', '0', 'JSON框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '400', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('150', 'eova_button_code', '1', '30', '', null, 'is_hide', '是否隐藏', '0', '布尔框', null, '0', '1', '0', '1', '0', '1', '1', '0', '0', null, null, '0', null, '60', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('151', 'eova_button_code', '1', '3', '', null, 'icon', 'ICON', '0', '图标框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, 'function(value,row,index,field){if(value){return\'<span class=\"tree-icon tree-file \'+value+\'\"></span>\'}return value}', '30', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('152', 'eova_button_code', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '50', '20', null, '50', '20', '4', 'INT', '10', '0'), ('153', 'eova_button_code', '1', '2', '', null, 'menu_code', '菜单编码', '0', '查找框', 'select code 菜单编码,name 菜单名称 from eova_menu where 1=1;ds=eova', '0', '1', '0', '1', '1', '1', '0', '0', '0', null, 'eovacode', null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('154', 'eova_button_code', '1', '4', '', null, 'name', '功能名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('155', 'eova_button_code', '1', '10', '', null, 'ui', 'UI路径', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '280', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('156', 'eova_button_code', '1', '20', '', null, 'bs', 'BS路径', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '250', '20', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('157', 'eova_button_code', '1', '6', '', null, 'order_num', '序号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '按钮的显示顺序', 'digits', '0', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('158', 'eova_button_code', '1', '7', '', null, 'group_num', '分组号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', 'Toolbar分组号', 'digits', '0', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('159', 'eova_button_code', '1', '8', '', null, 'is_base', '是否基础功能', '0', '布尔框', null, '0', '0', '0', '1', '0', '0', '0', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('201', 'eova_user_code', '1', '2', '', null, 'login_id', '登录帐号', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '30', '0'), ('202', 'eova_user_code', '1', '4', '', null, 'login_pwd', '登录密码', '0', '文本框', null, '0', '0', '0', '0', '1', '0', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '50', '12', 'VARCHAR', '50', '0'), ('203', 'eova_user_code', '1', '3', '', null, 'rid', '角色', '0', '下拉框', 'select id ID,name CN from eova_role where lv > ${user.role.lv};ds=eova', '1', '1', '0', '1', '1', '1', '0', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('204', 'eova_user_code', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('220', 'eova_role_code', '1', '0', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('221', 'eova_role_code', '1', '1', '', null, 'name', '角色名', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('222', 'eova_role_code', '1', '3', '', null, 'info', '角色描述', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '0', '1', '0', null, null, null, null, '230', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('223', 'eova_role_code', '1', '2', '', null, 'lv', '权限级别', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('260', 'eova_log_code', '1', '1', '', null, 'id', 'id', '1', '自增框', '', '0', '1', '0', '1', '1', '1', '0', '0', '0', '', '', null, '', '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('261', 'eova_log_code', '1', '2', '', null, 'user_id', '操作用户', '0', '查找框', 'select id UID,login_id 用户名 from eova_user where 1=1;ds=eova', '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('262', 'eova_log_code', '1', '3', '', '', 'type', '日志类型', '0', '下拉框', 'select value ID,name CN from eova_dict where object = \'eova_log\' and field = \'type\';ds=eova', '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('263', 'eova_log_code', '1', '4', '', null, 'ip', '操作IP', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '0', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('264', 'eova_log_code', '1', '5', '', null, 'info', '详情', '0', '文本框', '', '1', '1', '0', '0', '0', '0', '0', '1', '0', '', '', null, '', '330', '20', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('265', 'eova_log_code', '1', '6', '', null, 'create_time', '操作时间', '0', '时间框', '', '1', '1', '0', '0', '0', '0', '0', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '1', '0'), ('280', 'eova_task_code', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '50', '20', null, '50', '20', '4', 'INT', '10', '0'), ('281', 'eova_task_code', '1', '2', '', null, 'state', '状态', '0', '下拉框', 'select value ID,name CN from eova_dict where object = \'eova_job\' and field = \'state\';ds=eova', '1', '1', '0', '1', '0', '0', '0', '1', '0', null, null, '0', null, '50', '20', null, '0', '0', '4', 'INT', '10', '0'), ('282', 'eova_task_code', '1', '3', '', null, 'name', '名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', '任务简称', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('283', 'eova_task_code', '1', '4', '', null, 'exp', '表达式', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', 'Quartz表达式', '', null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('284', 'eova_task_code', '1', '5', '', null, 'clazz', '实现类', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', 'Job实现类', null, null, null, '230', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('285', 'eova_task_code', '1', '6', '', null, 'info', '说明', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', '任务的详细描述', null, null, null, '330', '50', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2000', 'celledit_users_code', '1', '1', '', null, 'id', 'id', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2001', 'celledit_users_code', '1', '2', '', null, 'status', '状态', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '0', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2002', 'celledit_users_code', '1', '3', '', null, 'login_id', '登录账户', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2003', 'celledit_users_code', '1', '4', '', null, 'login_pwd', '录登密码', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '0', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2004', 'celledit_users_code', '1', '5', '', null, 'nickname', '昵称', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2005', 'celledit_users_code', '1', '6', '', null, 'reg_time', '注册时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '93', 'TIMESTAMP', '19', '0'), ('2006', 'celledit_users_code', '1', '7', '', null, 'info', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2012', 'dicts', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2013', 'dicts', '1', '2', '', null, 'value', '值', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2014', 'dicts', '1', '3', '', null, 'name', '名称', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2015', 'dicts', '1', '4', '', null, 'object', '表名', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2016', 'dicts', '1', '5', '', null, 'field', '字段名', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2017', 'dicts', '1', '6', '', null, 'ext', '扩展Json', '0', '文本框', null, '0', '0', '0', '0', '0', '0', '0', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2018', 'hotel', '1', '11', '', null, 'province', '省', '0', '下拉框', 'select id ID,name CN from area where lv = 1;ds=main', '0', '1', '0', '0', '1', '1', '0', '1', '0', null, '', null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2019', 'hotel', '1', '12', '', null, 'city', '市', '0', '下拉框', 'select id ID,name CN from area where lv = 2;ds=main', '0', '1', '0', '0', '1', '1', '0', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2020', 'hotel', '1', '13', '', null, 'region', '区', '0', '下拉框', 'select id ID,name CN from area where lv = 3;ds=main', '0', '1', '0', '0', '1', '1', '0', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2021', 'hotel', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2022', 'hotel', '1', '3', '', null, 'name', '酒店名', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, '', null, 'function(value,row,index,field){var url=\'/single_grid/list/biz_demo_hotel_stock?query_hotel_id=\'+row.id;return \'<a href=\"javascript:parent.addTab(\\\'\'+row.name+\'库存\\\',\\\'\'+url+\'\\\',\\\'icon-building\\\');\" style=\"color:blue\">\'+value+\'</a>\';}', '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2023', 'hotel', '1', '4', '', null, 'tel', '电话', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2024', 'hotel', '1', '10', '', null, 'address', '详细地址', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '250', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2025', 'hotel', '1', '8', '', null, 'create_time', '创建时间', '0', '日期框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, '', null, null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('2026', 'hotel', '1', '7', '', null, 'state', '商户状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'hotel\' and field = \'state\';ds=main', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2027', 'hotel', '1', '7', '', null, 'score', '积分', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2028', 'hotel_bed', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2029', 'hotel_bed', '1', '2', '', null, 'hotel_id', '酒店', '0', '下拉框', 'select id ID,name CN from hotel where 1=1;ds=main', '1', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2030', 'hotel_bed', '1', '3', '', null, 'sizes', '床铺尺码', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'size\';ds=main', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2031', 'hotel_bed', '1', '4', '', null, 'num', '数量', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2032', 'hotel_stock', '1', '1', '', null, 'id', 'ID', '1', '自增框', '', '0', '0', '0', '1', '1', '1', '1', '0', '0', '', '', null, '', '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2033', 'hotel_stock', '1', '2', '', null, 'hotel_id', '酒店', '0', '下拉框', 'select id ID,name CN from hotel where 1=1;ds=main', '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2034', 'hotel_stock', '1', '3', '', null, 'category', '商品类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'category\';ds=main', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2035', 'hotel_stock', '1', '4', '', null, 'num', '存货量', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2036', 'item_code', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2037', 'item_code', '1', '5', '', null, 'name', '名称', '0', '文件框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2038', 'item_code', '1', '4', '', null, 'info', '介绍', '0', '编辑框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', null, null, 'function(value,row,index,field){if(value&&value.length>10){return \'<span title=\"\'+value+\'\">\'+value+\'</span>\';}return value;}', '200', '20', null, '0', '0', '12', 'VARCHAR', '1000', '0'), ('2039', 'item_code', '1', '6', '', null, 'img', '图片', '0', '图片框', '', '0', '1', '0', '1', '1', '1', '1', '1', '0', '', '', null, 'function(value,row,index,field){if(value){return \'<img src=\"/upimg/\'+value+\'\">\';}return value;}', '200', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2041', 'orders', '1', '100', '', '', 'diy_fun', '关联', '0', '文本框', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '', '', '', 'function(value,row,index,field){return\'<a target=\"_blank\" href=\"/singleGrid/list/biz_comment?query_order_id=\'+row.id+\'\" style=\"color:blue\">查看评价</a> <a target=\"_blank\" href=\"/form/update/payment-\'+row.pay_id+\'\" style=\"color:blue\">支付详情</a>\'}', '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2042', 'orders', '1', '1', '', null, 'hotel_id', '酒店', '0', '查找框', 'select id ID,name 酒店名,address 地址 from hotel', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2043', 'orders', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2044', 'orders', '1', '6', '', null, 'pay_id', '支付ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2045', 'orders', '1', '3', '', null, 'state', '订单状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'orders\' and field = \'state\';ds=main', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '10', null, '130', '20', null, '0', '0', '4', 'INT UNSIGNED', '10', '0'), ('2046', 'orders', '1', '4', '', null, 'money', '应付金额', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0.00', null, '130', '20', null, '0', '0', '8', 'DOUBLE UNSIGNED', '10', '2'), ('2047', 'orders', '1', '5', '', null, 'score', '消耗积分', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0.00', null, '130', '20', null, '0', '0', '8', 'DOUBLE UNSIGNED', '10', '2'), ('2048', 'orders', '1', '6', '', null, 'memo', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '256', '0'), ('2049', 'orders', '1', '7', '', null, 'create_user_id', '创建用户ID', '0', '查找框', 'select id UID,login_id 用户名 from eova_user where 1=1;ds=eova', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2050', 'orders', '1', '8', '', null, 'update_user_id', '最后更新人', '0', '查找框', 'select id UID,login_id 用户名 from eova_user where 1=1;ds=eova', '1', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2051', 'orders', '1', '9', '', null, 'create_time', '订单时间', '0', '日期框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('2052', 'orders', '1', '10', '', null, 'update_time', '更新时间', '0', '日期框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('2053', 'orders', '1', '11', '', null, 'is_invoice', '是否开票', '0', '布尔框', 'select value ID,name CN from dicts where object = \'orders\' and field = \'is_invoice\';ds=main', '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('2054', 'orders', '1', '12', '', null, 'additional_info', '订单补充信息(JSON格式)', '0', '文本域', null, '0', '0', '0', '0', '0', '0', '0', '1', '0', null, null, null, '', '130', '20', null, '0', '0', '12', 'VARCHAR', '1000', '0'), ('2055', 'order_item', '1', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT UNSIGNED', '10', '0'), ('2056', 'order_item', '1', '2', '', null, 'order_id', '订单ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2057', 'order_item', '1', '3', '', null, 'product', '产品', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '230', '20', null, '0', '0', '12', 'VARCHAR', '128', '0'), ('2058', 'order_item', '1', '4', '', null, 'price', '单价', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '8', 'DOUBLE', '10', '0'), ('2059', 'order_item', '1', '5', '', null, 'num', '购买数量', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT UNSIGNED', '10', '0'), ('2060', 'payment', '1', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '0', 'int', '1', '0'), ('2061', 'payment', '1', '2', '', null, 'relation_id', '订单ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2062', 'payment', '1', '3', '', null, 'subject', '商品名', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2063', 'payment', '1', '4', '', null, 'money', '支付金额', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0.00', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2064', 'payment', '1', '5', '', null, 'platform', '支付平台', '0', '下拉框', 'select value ID,name CN from dicts where object = \'payment\' and field = \'platform\';ds=main', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2065', 'payment', '1', '6', '', null, 'pay_business', '支付业务', '0', '下拉框', 'select value ID,name CN from dicts where object = \'payment\' and field = \'pay_business\';ds=main', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2066', 'payment', '1', '7', '', null, 'pay_sequence', '支付流水号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2067', 'payment', '1', '8', '', null, 'platform_sequence', '平台流水号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2068', 'payment', '1', '9', '', null, 'bank_sequence', '银行流水号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2069', 'payment', '1', '10', '', null, 'status', '支付状态', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2070', 'payment', '1', '11', '', null, 'failed_reason', '支付失败原因', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'varchar', '1', '0'), ('2071', 'payment', '1', '20', '', null, 'extend_info', '支付扩展信息', '0', '文本域', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '', null, '130', '120', null, '0', '0', '0', 'varchar', '1', '0'), ('2072', 'payment', '1', '2', '', null, 'create_user_id', '创建用户ID', '0', '查找框', 'select id UID,login_id 用户名 from eova_user where 1=1;ds=eova', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2073', 'payment', '1', '14', '', null, 'create_time', '创建时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'datetime', '1', '0'), ('2074', 'payment', '1', '15', '', null, 'update_time', '更新时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '0', 'datetime', '1', '0'), ('2075', 'player_code', '1', '10', '', '', 'tag', '标签', '0', '下拉框', 'select value ID , name CN from dicts where object = \'users\' and field = \'tag\'', '1', '1', '0', '1', '1', '1', '1', '1', '1', '', '', '', '', '130', '20', '', '0', '0', '12', 'VARCHAR', '255', '0'), ('2076', 'player_code', '1', '0', '', '', 'id', 'ID', '1', '自增框', '', '0', '1', '0', '1', '1', '1', '0', '0', '0', '', '', '', '', '130', '20', '', '50', '20', '4', 'INT', '10', '0'), ('2077', 'player_code', '1', '2', '', '', 'status', '状态', '0', '下拉框', 'select value ID , name CN from dicts where object = \'users\' and field = \'status\' or object = \'${user.id}\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '0', '', '130', '20', '', '0', '0', '4', 'INT', '10', '0'), ('2078', 'player_code', '1', '3', '', '', 'login_id', '登录账户', '0', '文本框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '0', '0', '12', 'VARCHAR', '255', '0'), ('2079', 'player_code', '1', '4', '', '', 'login_pwd', '录登密码', '0', '密码框', '', '0', '1', '1', '1', '1', '1', '0', '1', '0', '', '', '', '', '130', '20', '', '0', '0', '12', 'VARCHAR', '255', '0'), ('2080', 'player_code', '1', '1', '', '', 'nickname', '艺人姓名', '0', '文本框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', 'function(value,row,index,field){if(value){return \'<b style=\"color:red\">\'+value+\'</b>\';}return value;}', '130', '20', '', '0', '0', '12', 'VARCHAR', '255', '0'), ('2081', 'player_code', '1', '6', '', '', 'reg_time', '注册时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '180', '20', '', '0', '0', '93', 'TIMESTAMP', '19', '0'), ('2082', 'player_code', '1', '9', '', '', 'info', '备注', '0', '文本域', '', '0', '1', '0', '1', '0', '0', '0', '1', '0', '', '', '', '', '130', '20', '', '0', '0', '12', 'VARCHAR', '255', '0'), ('2083', 'product', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '70', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2084', 'product', '1', '2', '', null, 'type', '产品类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'type\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '70', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2085', 'product', '1', '3', '', null, 'category', '分类', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'category\'', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '70', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2086', 'product', '1', '4', '', null, 'stuff', '材料', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'stuff\'', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '70', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2087', 'product', '1', '5', '', null, 'sizes', '尺码', '0', '下拉框', 'select value ID,name CN from dicts where object = \'product\' and field = \'size\'', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '70', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2088', 'product', '1', '6', '', null, 'name', '名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '200', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2089', 'product', '1', '1', '', null, 'img', '商品图片', '0', '图片框', null, '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', '{\"filedir\":\"/image/bucao/product\"}', '0', '0', '12', 'VARCHAR', '255', '0'), ('2090', 'product', '1', '8', '', null, 'test_price', '试用单价', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '8', 'DOUBLE', '22', '0'), ('2091', 'product', '1', '9', '', null, 'price', '商品单价', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '8', 'DOUBLE', '22', '0'), ('2092', 'product', '1', '10', '', null, 'cost_score', '消耗积分', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2093', 'product', '1', '11', '', null, 'score', '奖励积分', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2094', 'product', '1', '12', '', null, 'stock', '库存', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2095', 'product', '1', '13', '', null, 'create_time', '创建时间', '0', '日期框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('2096', 'product', '1', '14', '', null, 'update_time', '更新时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '93', 'TIMESTAMP', '19', '0'), ('2097', 'users_exp_code', '1', '1', '', null, 'users_id', 'users_id', '0', '文本框', '', '0', '1', '0', '1', '1', '1', '1', '0', '0', '', null, null, '', '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2098', 'users_exp_code', '1', '2', '', null, 'exp', '经验值', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2099', 'users_exp_code', '1', '3', '', null, 'avg', '年龄', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2100', 'users_exp_code', '1', '4', '', null, 'qq', 'QQ', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2101', 'users_item_code', '1', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2102', 'users_item_code', '1', '2', '', null, 'users_id', '艺人', '0', '查找框', 'select id UID,login_id CN from users where <%if(user.id != 0){%>  id > ${user.id}<%}%> order by id desc', '1', '1', '0', '0', '1', '1', '1', '0', '0', null, null, null, 'function(value,row,index,field){return\'<a target=\"_blank\" href=\"http://g.cn\" style=\"color:blue\">\'+value+\'</a>\'}', '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2103', 'users_item_code', '1', '3', '', null, 'item_id', '道具', '0', '下拉框', 'select id ID,name CN from item where 1=1;ds=main', '1', '1', '0', '0', '1', '1', '1', '0', '0', null, null, null, null, '300', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2104', 'users_item_code', '1', '4', '', '', 'my_fun', '操作', '0', '文本框', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '', null, '', 'function(value,row,index,field){return\'<a href=\"/form/add/users_item_code\" style=\"color:blue\">添加</a> <a href=\"/form/update/users_item_code-\'+row.id+\'\" style=\"color:blue\">修改</a>\'}', '130', '20', null, '0', '0', '0', 'int', '1', '0'), ('2115', 'data_login', '1', '1', '', null, 'id', 'id', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2116', 'data_login', '1', '2', '', null, 'day', '日期', '0', '日期框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '91', 'DATE', '10', '0'), ('2117', 'data_login', '1', '3', '', null, 'num', '每日登录数', '0', '数字框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2132', 'user_info_code', '1', '1', '基本信息', null, 'id', 'id', '0', '查找框', 'select id ID,login_id 帐号 from eova_user;ds=eova', '0', '0', '0', '1', '1', '1', '1', '0', '0', '', null, null, null, '130', '20', null, '20', '20', '4', 'INT', '10', '0'), ('2133', 'user_info_code', '1', '2', '基本信息', null, 'rid', '冗余角色ID', '0', '文本框', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', null, '130', '20', null, '50', '50', '4', 'INT', '10', '0'), ('2134', 'user_info_code', '1', '5', '基本信息', null, 'status', '状态', '0', '下拉框', 'select value ID , name CN from dicts where object = \'users\' and field = \'status\' or object = \'${user.id}\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2135', 'user_info_code', '1', '6', '基本信息', null, 'nickname', '昵称', '0', '文本框', '', '0', '1', '0', '1', '1', '1', '1', '1', '0', '', null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '30', '0'), ('2136', 'user_info_code', '1', '7', '基本信息', null, 'mobile', '联系手机', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '11', '0'), ('2137', 'user_info_code', '2', '8', '地区信息', null, 'province', '省', '0', '下拉框', 'select id ID,name CN from area where lv = 1', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2138', 'user_info_code', '2', '9', '地区信息', null, 'city', '市', '0', '下拉框', 'select id ID,name CN from area where lv = 2', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2139', 'user_info_code', '2', '10', '地区信息', null, 'region', '区', '0', '下拉框', 'select id ID,name CN from area where lv = 3', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2140', 'user_info_code', '1', '30', '基本信息', null, 'create_time', '创建时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '10', '93', 'TIMESTAMP', '19', '0'), ('2388', 'test_info', '0', '1', '', null, 'id', 'ID', '1', '自增框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2389', 'test_info', '0', '2', '', null, 'user_id', '用户', '0', '查找框', 'select id ID,login_id 帐号 from eova_user;ds=eova', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '10', '4', 'INT', '10', '0'), ('2390', 'test_info', '0', '3', '基础信息', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'test_info\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2391', 'test_info', '0', '4', '基础信息', null, 'name', '姓名', '0', '文本框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2392', 'test_info', '0', '5', '基础信息', null, 'age', '年龄', '0', '数字框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2393', 'test_info', '2', '60', '详细信息', null, 'memo', '备注', '0', '编辑框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '200', null, '0', '0', '-1', 'TEXT', '65535', '0'), ('2394', 'test_info', '0', '2', '', null, 'avatar', '头像', '0', '图片框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', '', null, null, 'function(value,row,index,field){if(value){return \'<img src=\"\'+IMG+\'/avatar/\'+value+\'\" height=25>\'}return value}', '130', '20', '{\"filedir\":\"/avatar\"}', '0', '0', '12', 'VARCHAR', '255', '0'), ('2395', 'test_info', '1', '8', '操作时间', null, 'update_time', '更新日期', '0', '日期框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '10', '91', 'DATE', '10', '0'), ('2396', 'test_info', '1', '9', '操作时间', null, 'create_time', '创建时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, 'CURRENT_TIMESTAMP', null, '130', '20', null, '50', '10', '93', 'TIMESTAMP', '19', '0'), ('2397', 'test_info', '2', '12', '详细信息', null, 'delete_flag', '是否删除', '0', '布尔框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('2398', 'test_info', '2', '10', '详细信息', null, 'address', '详细地址', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '40', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2399', 'test_info', '2', '10', '详细信息', null, 'id_card', '身份证图片', '0', '文件框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2400', 'test_info', '2', '10', '详细信息', null, 'password', '密码', '0', '密码框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '50', '12', 'VARCHAR', '255', '0'), ('2401', 'test_info', '2', '10', '详细信息', null, 'color', '颜值', '0', '颜色框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '10', '0'), ('2624', 'test_info', '0', '4', '基础信息', null, 'tag', '标签', '0', '查找框', 'select value ID,name CN from dicts where object = \'test_info\' and field = \'tag\'', '1', '1', '0', '1', '1', '1', '1', '0', '1', '不推荐使用此法，使用下拉框吧！', null, null, null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2628', 'test_info', '3', '19', '测试信息', null, 'test4', 'test4', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '-7', 'BIT', '0', '0'), ('2629', 'test_info', '3', '20', '测试信息', null, 'test5', 'test5', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '-5', 'BIGINT UNSIGNED', '20', '0'), ('2630', 'test_info', '3', '21', '测试信息', null, 'test6', 'test6', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '-6', 'TINYINT UNSIGNED', '3', '0'), ('2631', 'test_info', '3', '16', '测试信息', null, 'test1', 'test1', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '4', 'INT UNSIGNED', '10', '0'), ('2632', 'test_info', '3', '17', '测试信息', null, 'test2', 'test2', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '7', 'FLOAT', '12', '0'), ('2633', 'test_info', '3', '18', '测试信息', null, 'test3', 'test3', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, null, null, '130', '20', null, '0', '0', '8', 'DOUBLE', '22', '0'), ('2634', 'data_login', '1', '3', '', null, 'num1', '每日活跃数', '0', '数字框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, null, null, '130', '20', null, '0', '0', '0', 'INT', '1', '0'), ('2745', 'links', '0', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2746', 'links', '0', '2', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'links\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2747', 'links', '0', '3', '', null, 'name', '链接文本', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2748', 'links', '0', '4', '', null, 'url', '链接地址', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, 'http://www..com', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2749', 'links', '0', '5', '', null, 'title', '小标题', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2761', 'data_money', '0', '1', '', null, 'id', 'id', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2762', 'data_money', '0', '2', '', null, 'moon', '月份', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '11', '0'), ('2763', 'data_money', '0', '3', '', null, 'num', '手机销售额', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2764', 'data_money', '0', '4', '', null, 'num1', '电脑销售额', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2765', 'data_money', '0', '5', '', null, 'num2', '避孕套销售额', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2766', 'test_info', '3', '22', '测试信息', null, 'test7', 'datetime', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('2818', 'v_orders', '0', '1', '订单信息', 'orders', 'id', '编号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '50', '10', '4', 'INT', '10', '0'), ('2819', 'v_orders', '0', '2', '订单信息', 'orders', 'state', '订单状态', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '10', null, '130', '20', null, '0', '0', '4', 'INT UNSIGNED', '10', '0'), ('2820', 'v_orders', '0', '3', '订单信息', 'orders', 'money', '应付金额', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0.00', null, '130', '20', null, '0', '0', '8', 'DOUBLE UNSIGNED', '10', '2'), ('2821', 'v_orders', '0', '4', '订单信息', 'orders', 'memo', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '256', '0'), ('2822', 'v_orders', '2', '5', '买家信息', 'orders', 'create_user_id', '创建用户ID', '0', '查找框', 'select id ID,nickname 昵称 from users', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '100', null, '130', '20', null, '50', '10', '4', 'INT', '10', '0'), ('2823', 'v_orders', '0', '6', '订单信息', 'orders', 'create_time', '创建时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, 'CURRENT_TIMESTAMP', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('2824', 'v_orders', '1', '7', '收货人', 'orders', 'address_id', '收货地址ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', '', null, '100', null, '130', '20', null, '50', '10', '4', 'INT', '10', '0'), ('2825', 'v_orders', '1', '8', '收货人', 'address', 'name', '收件人', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2826', 'v_orders', '1', '9', '收货人', 'address', 'full', '详细地址', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2827', 'v_orders', '1', '10', '收货人', 'address', 'mobilephone', '收件人手机', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2828', 'v_orders', '2', '11', '买家信息', 'users', 'login_id', '买家帐号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '10', '12', 'VARCHAR', '255', '0'), ('2829', 'v_orders', '2', '12', '买家信息', 'users', 'nickname', '买家昵称', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '10', '12', 'VARCHAR', '255', '0'), ('2830', 'v_orders', '2', '13', '买家信息', 'users', 'info', '备注', '0', '文本域', null, '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2956', 'v_users', '0', '1', '用户信息', 'users', 'id', 'id', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2957', 'v_users', '0', '2', '用户信息', 'users', 'status', '状态', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2958', 'v_users', '0', '3', '用户信息', 'users', 'login_id', '登录账户', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2959', 'v_users', '0', '4', '用户信息', 'users', 'login_pwd', '录登密码', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2960', 'v_users', '0', '5', '用户信息', 'users', 'nickname', '昵称', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2961', 'v_users', '0', '6', '用户信息', 'users', 'reg_time', '注册时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'TIMESTAMP', '19', '0'), ('2962', 'v_users', '0', '7', '用户信息', 'users', 'info', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2963', 'v_users', '0', '8', '用户信息', 'users', 'tag', '标签', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2964', 'v_users', '2', '9', '拓展信息', 'users_exp', 'exp', '经验值', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2965', 'v_users', '2', '10', '拓展信息', 'users_exp', 'avg', '年龄', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2966', 'v_users', '2', '11', '拓展信息', 'users_exp', 'qq', 'QQ', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, 'qq;', '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2975', 'area', '0', '1', '', null, 'id', 'ID', '0', '文本框', null, '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2976', 'area', '0', '2', '', null, 'name', '名称', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2977', 'area', '0', '4', '', null, 'pid', '父级', '0', '文本框', '', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '10', '4', 'INT', '10', '0'), ('2978', 'area', '0', '3', '', null, 'lv', '级别', '0', '下拉框', 'select value ID,name CN from dicts where object = \'area\' and field = \'lv\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2979', 'area_city', '0', '1', '', null, 'id', 'ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('2980', 'area_city', '0', '2', '', null, 'name', '名称', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '50', '0'), ('2981', 'area_city', '0', '3', '', null, 'code', '父级编码', '0', '查找框', 'SELECT id ID, name 名称 FROM area', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '11', '0'), ('2982', 'sale_data', '0', '1', '', null, 'id', 'ID', '1', '自增框', null, '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('2983', 'sale_data', '0', '2', '', null, 'city_id', '城市ID', '0', '数字框', null, '0', '0', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '10', '10', '4', 'INT', '10', '0'), ('2984', 'sale_data', '0', '3', '', null, 'name', '商品', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('2985', 'sale_data', '0', '4', '', null, 'money', '销售额', '0', '数字框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '8', 'DOUBLE', '22', '0'), ('2992', 'test_info', '2', '61', '详细信息', null, 'json', '配置信息', '0', 'JSON框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '500', '0'), ('3129', 'v_orders', '0', '5', '订单信息', 'orders', 'update_user_id', '更新用户ID', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '10', '4', 'INT', '10', '0'), ('3130', 'v_orders', '0', '8', '订单信息', 'orders', 'update_time', '更新时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '10', '93', 'DATETIME', '19', '0'), ('3131', 'data_money', '0', '6', '', null, 'total', '销售总额(虚拟字段)', '0', '文本框', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', null, null, '', 'function(value,row,index,field){return row.num+row.num1+row.num2;}', '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3228', 'wxuser', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3229', 'wxuser', '0', '2', '', null, 'app_id', '开发者ID', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3230', 'wxuser', '0', '3', '', null, 'open_id', '用户标示', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3231', 'wxuser', '0', '4', '', null, 'subscribe_time', '关注', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3232', 'wxuser', '0', '5', '', null, 'unsubscribe_time', '取消关注', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3233', 'wxuser', '0', '6', '', null, 'nick_name', '昵称', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3234', 'wxuser', '0', '7', '', null, 'unionid', 'unionid', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3235', 'wxuser', '0', '8', '', null, 'privilege', '特权信息', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3236', 'wxuser', '0', '9', '', null, 'headimgurl', '图像', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3237', 'wxuser', '0', '10', '', null, 'country', '国家', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '10', '0'), ('3238', 'wxuser', '0', '11', '', null, 'city', '城市', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '10', '0'), ('3239', 'wxuser', '0', '12', '', null, 'province', '省份', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '10', '0'), ('3240', 'wxuser', '0', '13', '', null, 'sex', '性别', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_user\' and field = \'sex\'', '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3241', 'wxuser', '0', '14', '', null, 'remark', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3242', 'wxuser', '0', '15', '', null, 'update_time', '更新时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3243', 'wxuser', '0', '16', '', null, 'create_time', '创建时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3264', 'mxmessage', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3265', 'mxmessage', '0', '2', '', null, 'app_id', '开发者ID', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0');
INSERT INTO `eova_field` VALUES ('3266', 'mxmessage', '0', '3', '', null, 'open_id', '用户标示', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3267', 'mxmessage', '0', '4', '', null, 'type', '消息类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_message\' and field = \'type\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3268', 'mxmessage', '0', '5', '', null, 'content', '消息内容', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '-1', 'TEXT', '65535', '0'), ('3269', 'mxmessage', '0', '6', '', null, 'create_time', '创建时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3270', 'mxmessage', '0', '7', '', null, 'update_time', '更新时间', '0', '时间框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3271', 'wxsubmgs', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3272', 'wxsubmgs', '0', '2', '', null, 'app_id', '开发者ID', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3273', 'wxsubmgs', '0', '3', '', null, 'type', '回复类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_submsg\' and field = \'type\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3274', 'wxsubmgs', '0', '4', '', null, 'redpack_id', '红包编号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3275', 'wxsubmgs', '0', '5', '', null, 'article_key', '文章关键词', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3276', 'wxsubmgs', '0', '6', '', null, 'content', '内容', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '-1', 'TEXT', '65535', '0'), ('3277', 'wxsubmgs', '0', '7', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_submsg\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3278', 'wxsubmgs', '0', '8', '', '', 'create_time', '创建时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0'), ('3279', 'wxsubmgs', '0', '9', '', '', 'update_time', '更新时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0'), ('3280', 'wxadmin', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3281', 'wxadmin', '0', '2', '', null, 'nickname', '昵称', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3282', 'wxadmin', '0', '3', '', null, 'mobilephone', '手机号', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, 'mobile;', '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '11', '0'), ('3283', 'wxadmin', '0', '4', '', null, 'email', '邮箱', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, 'email;', '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3284', 'wxadmin', '0', '5', '', null, 'login_pwd', '登陆密码', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3285', 'wxadmin', '0', '6', '', null, 'rid', '角色编号', '0', '下拉框', 'select id ID,name CN from eova_role where lv >= ${user.role.lv};ds=eova', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3286', 'wxadmin', '0', '7', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_admin\' and field = \'status\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3287', 'wxadmin', '0', '8', '', null, 'address', '地址', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3288', 'wxadmin', '0', '9', '', null, 'create_time', '创建时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3289', 'wxadmin', '0', '10', '', null, 'update_time', '更新时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3290', 'wxconfig', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3291', 'wxconfig', '0', '2', '', null, 'uid', '所属用户', '0', '下拉框', 'select id ID ,nickname CN from wx_admin', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3292', 'wxconfig', '0', '3', '', null, 'rmid', '随机数', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3293', 'wxconfig', '0', '4', '', null, 'app_id', '开发者ID', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3294', 'wxconfig', '0', '5', '', null, 'app_secret', '开发者密码', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3295', 'wxconfig', '0', '6', '', null, 'token', '令牌', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, 'Javen', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3296', 'wxconfig', '0', '7', '', null, 'encrypt', '是否加密', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_config\' and field = \'encrypt\'', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3297', 'wxconfig', '0', '8', '', null, 'encrypt_key', '加密密钥', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3298', 'wxconfig', '0', '9', '', null, 'mch_id', '商户ID', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3299', 'wxconfig', '0', '10', '', null, 'api_key', 'API密钥', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3300', 'wxconfig', '0', '11', '', null, 'certpath', '证书路径', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3301', 'wxconfig', '0', '12', '', null, 'domain', '授权域名', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3302', 'wxconfig', '0', '13', '', null, 'subscribe_url', '未关注跳转页', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3303', 'wxconfig', '0', '14', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_config\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3304', 'wxconfig', '0', '15', '', '', 'update_time', '更新时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '0', '50', '93', 'DATETIME', '19', '0'), ('3305', 'wxconfig', '0', '16', '', '', 'create_time', '创建时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '0', '50', '93', 'DATETIME', '19', '0'), ('3306', 'wxmaterial', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3307', 'wxmaterial', '0', '2', '', null, 'app_id', '开发者ID', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3308', 'wxmaterial', '0', '3', '', null, 'keyword', '关键字', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3309', 'wxmaterial', '0', '4', '', null, 'type', '类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_material\' and field = \'type\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '2', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3310', 'wxmaterial', '0', '5', '', null, 'url', '文章链接', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3311', 'wxmaterial', '0', '6', '', null, 'image_url', '图片地址', '0', '图片框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3312', 'wxmaterial', '0', '7', '', null, 'title', '标题', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3313', 'wxmaterial', '0', '8', '', null, 'content', '内容', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '-1', 'TEXT', '65535', '0'), ('3314', 'wxmaterial', '0', '9', '', null, 'describe', '描述', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3315', 'wxmaterial', '0', '10', '', null, 'author', '作者', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3316', 'wxmaterial', '0', '11', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_material\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3317', 'wxmaterial', '0', '12', '', null, 'create_time', '创建时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3318', 'wxmaterial', '0', '13', '', null, 'update_time', '更新时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '93', 'DATETIME', '19', '0'), ('3328', 'wxkeyword', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3329', 'wxkeyword', '0', '2', '', null, 'app_id', '开发者ID ', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3330', 'wxkeyword', '0', '3', '', null, 'type', '消息类型', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_keyword\' and field = \'type\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3331', 'wxkeyword', '0', '4', '', null, 'key_word', '关键字', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3332', 'wxkeyword', '0', '5', '', null, 'content', '回复内容', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '-1', 'TEXT', '65535', '0'), ('3333', 'wxkeyword', '0', '6', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_keyword\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3334', 'wxkeyword', '0', '7', '', null, 'create_time', '创建时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3335', 'wxkeyword', '0', '8', '', null, 'update_time', '更新时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3336', 'wxkeyword', '0', '9', '', null, 'remake', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3337', 'wx_menutype', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3338', 'wx_menutype', '0', '2', '', null, 'type_name', '类型名称', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3339', 'wx_menutype', '0', '3', '', null, 'describe', '描述', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3340', 'wx_menutype', '0', '4', '', null, 'create_time', '创建时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3341', 'wx_menutype', '0', '5', '', null, 'update_time', '更新时间', '0', '时间框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '50', '50', '93', 'DATETIME', '19', '0'), ('3342', 'wx_menutype', '0', '6', '', null, 'remake', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3343', 'wx_custommenu', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3344', 'wx_custommenu', '0', '2', '', null, 'pid', '父节点', '0', '文本框', null, '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3345', 'wx_custommenu', '0', '3', '', null, 'app_id', '开发者ID', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3346', 'wx_custommenu', '0', '4', '', null, 'type_id', '菜单类型', '0', '下拉框', 'select id ID ,type_name CN from wx_menutype', '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '11', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3347', 'wx_custommenu', '0', '5', '', null, 'name', '菜单名称', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3348', 'wx_custommenu', '0', '6', '', null, 'url', '网页链接', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3349', 'wx_custommenu', '0', '7', '', null, 'key', '菜单key值', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3350', 'wx_custommenu', '0', '8', '', null, 'media_id', '素材id', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3351', 'wx_custommenu', '0', '9', '', null, 'sort', '排序', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3352', 'wx_custommenu', '0', '10', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_custommenu\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3353', 'wx_custommenu', '0', '11', '', null, 'xappid', '小程序的appid', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3354', 'wx_custommenu', '0', '12', '', null, 'pagepath', '小程序的页面路径', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3355', 'wx_custommenu', '0', '13', '', '', 'create_time', '创建时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0'), ('3356', 'wx_custommenu', '0', '14', '', '', 'update_time', '更新时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '0', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0'), ('3357', 'wx_custommenu', '0', '15', '', null, 'remake', '备注', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3376', 'wx_custommenu', '0', '12', '', '', 'menu_group', '菜单组', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '0', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3381', 'wx_matchrulemenu', '0', '1', '', null, 'id', '编号', '1', '自增框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '50', '20', '4', 'INT', '10', '0'), ('3382', 'wx_matchrulemenu', '0', '2', '', null, 'app_id', '开发者编号', '0', '文本域', null, '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3383', 'wx_matchrulemenu', '0', '3', '', null, 'tag_id', '用户标签', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3384', 'wx_matchrulemenu', '0', '4', '', null, 'sex', '性别', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_matchrulemenu\' and field = \'sex\'', '1', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3385', 'wx_matchrulemenu', '0', '5', '', null, 'client_platform_type', '客户端版本', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_matchrulemenu\' and field = \'client_platform_type\'', '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3386', 'wx_matchrulemenu', '0', '6', '', null, 'country', '国家信息', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3387', 'wx_matchrulemenu', '0', '7', '', null, 'province', '省份信息', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3388', 'wx_matchrulemenu', '0', '8', '', null, 'city', '城市信息', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3389', 'wx_matchrulemenu', '0', '9', '', null, 'language', '语言信息', '0', '文本域', null, '0', '1', '0', '1', '1', '1', '1', '0', '0', null, null, '', null, '130', '20', null, '0', '0', '12', 'VARCHAR', '255', '0'), ('3390', 'wx_matchrulemenu', '0', '10', '', null, 'menu_group', '菜单组', '0', '文本框', null, '0', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3391', 'wx_matchrulemenu', '0', '11', '', null, 'status', '状态', '0', '下拉框', 'select value ID,name CN from dicts where object = \'wx_matchrulemenu\' and field = \'status\'', '1', '1', '0', '1', '1', '1', '1', '1', '0', null, null, '1', null, '130', '20', null, '0', '0', '4', 'INT', '10', '0'), ('3392', 'wx_matchrulemenu', '0', '12', '', '', 'create_time', '创建时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0'), ('3393', 'wx_matchrulemenu', '0', '13', '', '', 'update_time', '更新时间', '0', '时间框', '', '1', '1', '0', '1', '1', '1', '1', '1', '0', '', '', '', '', '130', '20', '', '50', '50', '93', 'DATETIME', '19', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eova_log`
-- ----------------------------
DROP TABLE IF EXISTS `eova_log`;
CREATE TABLE `eova_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '操作用户',
  `type` int(11) NOT NULL COMMENT '日志类型',
  `ip` varchar(255) NOT NULL COMMENT '操作IP',
  `info` varchar(500) DEFAULT NULL COMMENT '操作详情',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8 COMMENT='EOVA操作日志';

-- ----------------------------
--  Records of `eova_log`
-- ----------------------------
BEGIN;
INSERT INTO `eova_log` VALUES ('1', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1000]', '2017-06-02 15:58:07'), ('2', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1125]', '2017-06-02 16:04:43'), ('3', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3137]', '2017-06-02 16:06:48'), ('4', '1', '1', '0:0:0:0:0:0:0:1', 'eova_role_code', '2017-06-02 16:07:17'), ('5', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3137]', '2017-06-02 16:08:03'), ('6', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3138]', '2017-06-02 16:08:03'), ('7', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3140]', '2017-06-02 16:08:03'), ('8', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3141]', '2017-06-02 16:08:03'), ('9', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3133]', '2017-06-02 16:08:03'), ('10', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1126]', '2017-06-02 16:09:26'), ('11', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3143]', '2017-06-02 16:09:58'), ('12', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:09:58'), ('13', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3143]', '2017-06-02 16:10:10'), ('14', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:10:10'), ('15', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3149]', '2017-06-02 16:10:45'), ('16', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3150]', '2017-06-02 16:10:45'), ('17', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:10:45'), ('18', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3143]', '2017-06-02 16:10:45'), ('19', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3143]', '2017-06-02 16:14:02'), ('20', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:14:02'), ('21', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3143]', '2017-06-02 16:15:42'), ('22', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:15:42'), ('23', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[2]', '2017-06-02 16:15:57'), ('24', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3149]', '2017-06-02 16:17:16'), ('25', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3150]', '2017-06-02 16:17:16'), ('26', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3140]', '2017-06-02 16:17:54'), ('27', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3141]', '2017-06-02 16:17:54'), ('28', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3134]', '2017-06-02 16:18:36'), ('29', '1', '1', '0:0:0:0:0:0:0:1', 'wxadmin', '2017-06-02 16:23:29'), ('30', '1', '1', '0:0:0:0:0:0:0:1', 'wxconfig', '2017-06-02 16:24:35'), ('31', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3144]', '2017-06-02 16:25:48'), ('32', '1', '4', '0:0:0:0:0:0:0:1', 'wxconfig', '2017-06-02 16:33:17'), ('33', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[3]', '2017-06-02 16:33:39'), ('34', '1', '4', '0:0:0:0:0:0:0:1', 'wxadmin', '2017-06-02 16:36:24'), ('35', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[3]', '2017-06-02 16:36:44'), ('36', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[4]', '2017-06-02 16:36:52'), ('37', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[5]', '2017-06-02 16:36:59'), ('38', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[6]', '2017-06-02 16:37:04'), ('39', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1126]', '2017-06-02 16:47:54'), ('40', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[6]', '2017-06-02 16:48:08'), ('41', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1126]', '2017-06-02 16:51:56'), ('42', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1126]', '2017-06-02 16:53:10'), ('43', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3151]', '2017-06-03 15:18:49'), ('44', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3154]', '2017-06-03 15:41:51'), ('45', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3153]', '2017-06-03 15:41:51'), ('46', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3155]', '2017-06-03 15:43:28'), ('47', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3156]', '2017-06-03 15:44:40'), ('48', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3157]', '2017-06-03 15:44:40'), ('49', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1126]', '2017-06-03 15:49:23'), ('50', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[9]', '2017-06-03 15:49:39'), ('51', '1', '1', '0:0:0:0:0:0:0:1', 'wxconfig', '2017-06-03 15:53:13'), ('52', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1127]', '2017-06-03 15:59:35'), ('53', '1', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-03 16:00:34'), ('54', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3161]', '2017-06-03 16:35:36'), ('55', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3165]', '2017-06-03 16:35:36'), ('56', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3162]', '2017-06-03 16:35:36'), ('57', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3164]', '2017-06-03 16:35:36'), ('58', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1062]', '2017-06-03 16:36:50'), ('59', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3168]', '2017-06-03 16:37:55'), ('60', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3169]', '2017-06-03 16:37:55'), ('61', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3168]', '2017-06-03 16:38:00'), ('62', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3169]', '2017-06-03 16:38:00'), ('63', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1128]', '2017-06-03 16:39:50'), ('64', '1', '1', '0:0:0:0:0:0:0:1', 'wxmaterial', '2017-06-03 16:40:44'), ('65', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[2]', '2017-06-03 16:44:50'), ('66', '1', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-03 16:45:16'), ('67', '1', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-03 16:57:33'), ('68', '1', '2', '0:0:0:0:0:0:0:1', 'wxsubmgs[2]', '2017-06-03 16:58:26'), ('69', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3153]', '2017-06-03 17:00:20'), ('70', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3161]', '2017-06-03 17:00:32'), ('71', '1', '2', '0:0:0:0:0:0:0:1', 'wxmaterial[1]', '2017-06-03 17:01:47'), ('72', '1', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-03 17:03:00'), ('73', '1', '2', '0:0:0:0:0:0:0:1', 'wxsubmgs[2]', '2017-06-03 17:03:10'), ('74', '1', '2', '0:0:0:0:0:0:0:1', 'wxsubmgs[3]', '2017-06-03 17:03:17'), ('75', '1', '2', '0:0:0:0:0:0:0:1', 'wxsubmgs[1]', '2017-06-03 17:03:22'), ('76', '1', '2', '0:0:0:0:0:0:0:1', 'wxsubmgs[4]', '2017-06-03 17:03:28'), ('77', '1', '1', '0:0:0:0:0:0:0:1', 'wxmaterial', '2017-06-03 17:03:54'), ('78', '1', '1', '0:0:0:0:0:0:0:1', 'wxmaterial', '2017-06-03 17:14:07'), ('79', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1128]', '2017-06-03 17:16:23'), ('80', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1127]', '2017-06-03 17:16:30'), ('81', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3154]', '2017-06-03 17:17:39'), ('82', '3', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-03 17:22:34'), ('83', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3172]', '2017-06-03 17:32:44'), ('84', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3173]', '2017-06-03 17:32:44'), ('85', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3171]', '2017-06-03 17:32:44'), ('86', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1129]', '2017-06-03 17:33:06'), ('87', '1', '1', '0:0:0:0:0:0:0:1', 'mxmessage', '2017-06-03 17:35:59'), ('88', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1129]', '2017-06-03 17:36:45'), ('89', '1', '1', '0:0:0:0:0:0:0:1', 'mxmessage', '2017-06-03 17:37:01'), ('90', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1130]', '2017-06-03 17:45:03'), ('91', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3178]', '2017-06-03 17:48:22'), ('92', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3179]', '2017-06-03 17:48:22'), ('93', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3191]', '2017-06-03 17:48:22'), ('94', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3192]', '2017-06-03 17:48:22'), ('95', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3178]', '2017-06-03 17:48:59'), ('96', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3178]', '2017-06-03 17:49:45'), ('97', '1', '1', '0:0:0:0:0:0:0:1', 'wxuser', '2017-06-03 17:51:36'), ('98', '1', '3', '0:0:0:0:0:0:0:1', 'wxuser[1]', '2017-06-03 17:51:41'), ('99', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1131]', '2017-06-03 17:54:09'), ('100', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3194]', '2017-06-03 17:54:32'), ('101', '1', '2', '0:0:0:0:0:0:0:1', 'wxuser[2]', '2017-06-03 17:56:41'), ('102', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1132]', '2017-06-03 18:10:53'), ('103', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3282]', '2017-06-22 22:24:24'), ('104', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3285]', '2017-06-22 22:24:24'), ('105', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3281]', '2017-06-22 22:24:24'), ('106', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3289]', '2017-06-22 22:24:24'), ('107', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3288]', '2017-06-22 22:24:24'), ('108', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3304]', '2017-06-22 22:29:56'), ('109', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3305]', '2017-06-22 22:30:06'), ('110', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3304]', '2017-06-22 22:31:42'), ('111', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3305]', '2017-06-22 22:31:42'), ('112', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3303]', '2017-06-22 22:31:42'), ('113', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3293]', '2017-06-22 22:31:42'), ('114', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3291]', '2017-06-22 22:31:42'), ('115', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3272]', '2017-06-22 22:34:07'), ('116', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3273]', '2017-06-22 22:34:07'), ('117', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3277]', '2017-06-22 22:34:07'), ('118', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3278]', '2017-06-22 22:34:07'), ('119', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3279]', '2017-06-22 22:34:07'), ('120', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3279]', '2017-06-22 22:34:17'), ('121', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3278]', '2017-06-22 22:34:24'), ('122', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3308]', '2017-06-22 22:36:16'), ('123', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3307]', '2017-06-22 22:36:16'), ('124', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3309]', '2017-06-22 22:36:16'), ('125', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3316]', '2017-06-22 22:36:16'), ('126', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3317]', '2017-06-22 22:36:16'), ('127', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3318]', '2017-06-22 22:36:16'), ('128', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3220]', '2017-06-22 22:41:40'), ('129', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3221]', '2017-06-22 22:41:40'), ('130', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3224]', '2017-06-22 22:41:40'), ('131', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3222]', '2017-06-22 22:41:40'), ('132', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3225]', '2017-06-22 22:41:40'), ('133', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3226]', '2017-06-22 22:41:40'), ('134', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3324]', '2017-06-22 22:46:59'), ('135', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3321]', '2017-06-22 22:46:59'), ('136', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3320]', '2017-06-22 22:46:59'), ('137', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3325]', '2017-06-22 22:46:59'), ('138', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3326]', '2017-06-22 22:46:59'), ('139', '1', '2', '0:0:0:0:0:0:0:1', 'wxkeyword[2]', '2017-06-22 22:47:45'), ('140', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3329]', '2017-06-22 22:49:31'), ('141', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3330]', '2017-06-22 22:49:31'), ('142', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3333]', '2017-06-22 22:49:31'), ('143', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3335]', '2017-06-22 22:49:31'), ('144', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3334]', '2017-06-22 22:49:31'), ('145', '1', '1', '0:0:0:0:0:0:0:1', 'wxkeyword', '2017-06-22 22:52:03'), ('146', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1063]', '2017-06-22 22:52:51'), ('147', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1144]', '2017-06-22 23:00:08'), ('148', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3338]', '2017-06-22 23:00:59'), ('149', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3340]', '2017-06-22 23:00:59'), ('150', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3341]', '2017-06-22 23:00:59'), ('151', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1066]', '2017-06-22 23:13:49'), ('152', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1067]', '2017-06-22 23:18:01'), ('153', '1', '2', '0:0:0:0:0:0:0:1', 'eova_menu_code[1063]', '2017-06-22 23:18:22'), ('154', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3278]', '2017-06-24 13:23:14'), ('155', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3279]', '2017-06-24 13:23:14'), ('156', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1138]', '2017-06-24 13:24:15'), ('157', '1', '1', '0:0:0:0:0:0:0:1', 'wxsubmgs', '2017-06-24 13:24:29'), ('158', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3376]', '2017-06-24 13:36:50'), ('159', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3346]', '2017-06-24 13:40:25'), ('160', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3346]', '2017-06-24 13:42:10'), ('161', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 13:42:41'), ('162', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 13:43:32'), ('163', '1', '2', '0:0:0:0:0:0:0:1', 'wx_matchrulemenu[1]', '2017-06-24 13:44:38'), ('164', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 14:40:10'), ('165', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 14:41:07'), ('166', '1', '1', '0:0:0:0:0:0:0:1', 'wx_matchrulemenu', '2017-06-24 14:44:11'), ('167', '1', '3', '0:0:0:0:0:0:0:1', 'wx_custommenu[16]', '2017-06-24 14:55:51'), ('168', '1', '2', '0:0:0:0:0:0:0:1', 'wx_custommenu[20]', '2017-06-24 15:07:56'), ('169', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 15:08:43'), ('170', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1148]', '2017-06-24 17:48:36'), ('171', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1145]', '2017-06-24 17:48:55'), ('172', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1143]', '2017-06-24 17:49:12'), ('173', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1141]', '2017-06-24 17:49:39'), ('174', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1139]', '2017-06-24 17:55:00'), ('175', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1140]', '2017-06-24 17:55:44'), ('176', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1140]', '2017-06-24 17:56:39'), ('177', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1138]', '2017-06-24 17:57:17'), ('178', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[2]', '2017-06-24 18:17:41'), ('179', '1', '2', '0:0:0:0:0:0:0:1', 'wxconfig[2]', '2017-06-24 18:18:15'), ('180', '1', '1', '0:0:0:0:0:0:0:1', 'wx_matchrulemenu', '2017-06-24 18:18:45'), ('181', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3392]', '2017-06-24 18:19:37'), ('182', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3392]', '2017-06-24 18:19:51'), ('183', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3393]', '2017-06-24 18:19:59'), ('184', '1', '1', '0:0:0:0:0:0:0:1', 'wx_matchrulemenu', '2017-06-24 18:20:14'), ('185', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 18:20:57'), ('186', '1', '1', '0:0:0:0:0:0:0:1', 'wx_custommenu', '2017-06-24 18:21:31'), ('187', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3355]', '2017-06-24 18:22:25'), ('188', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3356]', '2017-06-24 18:22:34'), ('189', '1', '2', '0:0:0:0:0:0:0:1', 'wx_custommenu[22]', '2017-06-24 18:23:10'), ('190', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1145]', '2017-06-24 18:23:52'), ('191', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1145]', '2017-06-24 18:26:28'), ('192', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3345]', '2017-06-24 18:27:20'), ('193', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3344]', '2017-06-24 18:27:20'), ('194', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3352]', '2017-06-24 18:27:20'), ('195', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3356]', '2017-06-24 18:27:20'), ('196', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3355]', '2017-06-24 18:27:20'), ('197', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3391]', '2017-06-24 18:27:57'), ('198', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3392]', '2017-06-24 18:27:57'), ('199', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3393]', '2017-06-24 18:27:57'), ('200', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3384]', '2017-06-24 18:27:57'), ('201', '1', '2', '0:0:0:0:0:0:0:1', 'eova_field_code[3382]', '2017-06-24 18:27:57'), ('202', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1145]', '2017-06-24 18:30:09'), ('203', '1', '2', '0:0:0:0:0:0:0:1', 'eova_object_code[1145]', '2017-06-24 18:30:36');
COMMIT;

-- ----------------------------
--  Table structure for `eova_menu`
-- ----------------------------
DROP TABLE IF EXISTS `eova_menu`;
CREATE TABLE `eova_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL COMMENT '编码',
  `name` varchar(100) NOT NULL COMMENT '名称',
  `type` varchar(20) NOT NULL COMMENT '菜单类型',
  `iconskip` varchar(255) DEFAULT NULL COMMENT '图标',
  `order_num` int(11) DEFAULT '0' COMMENT '序号',
  `parent_id` int(11) DEFAULT '0' COMMENT '父节点',
  `open` tinyint(1) DEFAULT '1' COMMENT '是否展开',
  `biz_intercept` varchar(255) DEFAULT NULL COMMENT '自定义业务拦截器',
  `url` varchar(255) DEFAULT NULL COMMENT '自定义URL',
  `config` varchar(500) DEFAULT NULL COMMENT '菜单配置JSON',
  `diy_js` varchar(255) DEFAULT NULL COMMENT '依赖JS文件',
  `is_hide` tinyint(1) DEFAULT '0' COMMENT '是否隐藏',
  `filter` varchar(500) DEFAULT NULL COMMENT '初始数据过滤条件',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=1069 DEFAULT CHARSET=utf8 COMMENT='EOVA菜单';

-- ----------------------------
--  Records of `eova_menu`
-- ----------------------------
BEGIN;
INSERT INTO `eova_menu` VALUES ('1', 'eova', '平台维护', 'dir', 'eova-icon169', '3', '0', '0', null, null, null, null, '0', null), ('3', 'biz', '综合业务', 'dir', 'eova-icon877', '1', '0', '1', '', null, '', '', '0', ''), ('20', 'eova_menu', '菜单管理', 'single_tree', 'eova-icon43', '1', '1', '1', null, null, '{\"objectCode\":\"eova_menu_code\",\"tree\":{\"iconField\":\"iconskip\",\"parentField\":\"parent_id\",\"treeField\":\"name\",\"idField\":\"id\",\"rootPid\":\"0\"}}', null, '0', null), ('21', 'eova_button', '按钮管理', 'tree_grid', 'eova-icon169', '2', '1', '1', '', null, '{\"objectCode\":\"eova_button_code\",\"objectField\":\"menu_code\",\"tree\":{\"iconField\":\"iconskip\",\"idField\":\"id\",\"objectCode\":\"eova_menu_code\",\"objectField\":\"code\",\"parentField\":\"parent_id\",\"treeField\":\"name\",\"rootPid\":\"0\"}}', '', '0', ''), ('22', 'eova_object', '元数据管理', 'master_slave_grid', 'eova-icon395', '3', '1', '1', null, null, '{\"fields\":[\"object_code\"],\"objectCode\":\"eova_object_code\",\"objectField\":\"code\",\"objects\":[\"eova_field_code\"]}', null, '0', null), ('25', 'eova_task', '定时调度', 'single_grid', 'eova-icon280', '4', '1', '1', null, '', '{\"objectCode\":\"eova_task_code\"}', null, '0', null), ('900', 'sys', '系统管理', 'dir', 'eova-icon294', '1', '0', '0', null, null, null, null, '0', null), ('901', 'sys_auth_users', '用户管理', 'master_slave_grid', 'eova-icon518', '1', '900', '1', '', '', '{\"fields\":[\"id\"],\"objectCode\":\"eova_user_code\",\"objectField\":\"id\",\"objects\":[\"user_info_code\"]}', '', '0', ''), ('902', 'sys_auth_role', '角色管理', 'single_grid', 'eova-icon525', '2', '900', '1', '', null, '{\"objectCode\":\"eova_role_code\"}', '', '0', ''), ('903', 'sys_log', '系统日志', 'single_grid', 'eova-icon1058', '3', '900', '1', '', null, '{\"objectCode\":\"eova_log_code\"}', '', '0', ''), ('1000', 'biz_demo', '功能演示', 'dir', 'eova-icon145', '2', '3', '0', '', null, '', '', '0', ''), ('1001', 'biz_demo_users', '单表CRUD', 'single_grid', 'eova-icon49', '2', '1000', '1', '', '', '{\"objectCode\":\"player_code\"}', '', '0', ''), ('1005', 'biz_demo_userscell', '表格单元格编辑', 'single_grid', 'eova-icon294', '5', '1000', '1', '', null, '{\"objectCode\":\"celledit_users_code\"}', '', '0', ''), ('1006', 'biz_demo_import', '导入导出', 'single_grid', 'eova-icon84', '6', '1000', '1', '', null, '{\"objectCode\":\"player_code\"}', '', '0', ''), ('1007', 'biz_users_exp', '非自增主键拓展表', 'single_grid', 'eova-icon22', '7', '1000', '1', '', '', '{\"objectCode\":\"users_exp_code\"}', '/ui/js/diy/test.js', '0', ''), ('1009', 'biz_product', '产品管理', 'single_grid', 'eova-icon160', '8', '1000', '1', '', '', '{\"objectCode\":\"product\"}', '', '0', ''), ('1010', 'biz_hotelzz', '酒店管理(主子)', 'master_slave_grid', 'eova-icon182', '9', '1000', '1', '', '', '{\"fields\":[\"hotel_id\",\"hotel_id\"],\"objectCode\":\"hotel\",\"objectField\":\"id\",\"objects\":[\"hotel_bed\",\"hotel_stock\"]}', '', '0', ''), ('1011', 'biz_caidan', '报表管理', 'dir', 'eova-icon271', '50', '1000', '1', '', '', '{}', '', '0', ''), ('1012', 'biz_4j', '只显示有子功能的目录', 'dir', 'eova-icon482', '0', '1000', '1', '', '', '{}', '', '1', ''), ('1013', 'biz_4j_test1', '没子的目录不显示', 'single_grid', 'icon-applicationosxcascade', '99', '1012', '1', '', '', '{\"objectCode\":\"player_code\"}', null, '1', null), ('1015', 'biz_data_login', '每日登录用户数', 'single_chart', 'eova-icon271', '1', '1011', '1', '', '', '{\"objectCode\":\"data_login\",\"chart\":{\"x\":\"day\",\"y\":[\"num\",\"num1\"],\"ycn\":[\"每日登陆数\",\"每日活跃数\"],\"yunit\":\"人\"}}', '', '0', ''), ('1029', 'biz_demo_eova_all', 'EOVA控件', 'single_grid', 'eova-icon11', '6', '3', '1', '', '', '{\"objectCode\":\"test_info\"}', '', '0', ''), ('1035', 'biz_demo_links', '友情链接管理', 'single_grid', 'eova-icon33', '10', '1000', '1', '', '', '{\"objectCode\":\"links\"}', '', '0', ''), ('1040', 'biz_demo_money', '销售额报表', 'single_chart', 'eova-icon271', '1', '1011', '1', '', '', '{\"chart\":{\"x\":\"moon\",\"y\":[\"num\",\"num1\",\"num2\"],\"ycn\":[\"手机销售额\",\"电脑销售额\",\"避孕套销售额\"],\"yunit\":\"元\"},\"objectCode\":\"data_money\"}', '', '0', ''), ('1044', 'biz_demo_views_orders', '订单管理', 'single_grid', 'eova-icon49', '1', '1046', '1', '', '', '{\"objectCode\":\"v_orders\"}', '', '0', ''), ('1046', 'biz_demo_views', '多表视图', 'dir', 'eova-icon21', '51', '1000', '1', '', '', '{}', '', '0', ''), ('1047', 'biz_demo_views_users', '多表用户信息', 'single_grid', 'eova-icon1121', '1', '1046', '1', '', '', '{\"objectCode\":\"v_users\"}', '', '0', ''), ('1048', 'biz_demo_area', '地区树管理', 'single_tree', 'eova-icon43', '11', '1000', '1', '', '', '{\"objectCode\":\"area\",\"tree\":{\"iconField\":\"\",\"idField\":\"id\",\"parentField\":\"pid\",\"treeField\":\"name\",\"rootPid\":\"0\"}}', '', '0', ''), ('1049', 'biz_demo_tree_code', '父字符串树', 'single_tree', 'eova-icon43', '12', '1000', '1', '', '', '{\"objectCode\":\"area_city\",\"tree\":{\"iconField\":\"\",\"idField\":\"id\",\"parentField\":\"code\",\"treeField\":\"name\",\"rootPid\":\"0\"}}', '', '0', ''), ('1050', 'biz_demo_sale', '全国销售数据', 'tree_grid', 'eova-icon129', '13', '1000', '1', '', '', '{\"objectCode\":\"sale_data\",\"objectField\":\"city_id\",\"tree\":{\"iconField\":\"\",\"idField\":\"id\",\"objectCode\":\"area_city\",\"parentField\":\"code\",\"rootPid\":\"0\",\"treeField\":\"name\",\"objectField\":\"id\"}}', '', '0', ''), ('1052', 'eova_code', '神器·代码仓库', 'diy', 'eova-icon157', '666', '1', '1', null, '/code', '{}', null, '0', null), ('1053', 'biz_demo_hotel', '酒店管理(关联)', 'single_grid', 'eova-icon182', '9', '1000', '1', '', '', '{\"objectCode\":\"hotel\"}', '', '0', ''), ('1054', 'biz_demo_hotel_stock', '酒店库存管理', 'single_grid', 'eova-icon182', '9', '1000', '1', '', '', '{\"objectCode\":\"hotel_stock\"}', '', '0', ''), ('1055', 'biz_demo_xls', '自定义模版导出', 'diy', 'eova-icon779', '5', '1011', '1', '', '/xls', '{}', '', '0', ''), ('1056', 'wxback', '微信后台', 'dir', 'eova-icon306', '1', '0', '1', null, '', '{}', null, '0', null), ('1057', 'druid', '性能监控', 'diy', 'eova-icon271', '9', '1056', '1', null, '/druid', '{}', null, '0', null), ('1058', 'wxlogin', '登录用户', 'single_grid', 'eova-icon518', '1', '1056', '1', null, '', '{\"objectCode\":\"wxadmin\"}', null, '0', null), ('1059', 'wxconfig', '微信配置', 'single_grid', 'eova-icon174', '1', '1056', '1', null, '', '{\"objectCode\":\"wxconfig\"}', null, '0', null), ('1060', 'eovadoc', 'Eova文档', 'diy', 'eova-icon473', '9', '3', '1', null, ' http://www.eova.cn/eovamain', '{}', null, '0', null), ('1061', 'submsg', '关注回复', 'single_grid', 'eova-icon527', '3', '1056', '1', null, '', '{\"objectCode\":\"wxsubmgs\"}', null, '0', null), ('1062', 'wxmaterialmgr', '素材管理', 'single_grid', 'eova-icon1080', '4', '1056', '1', '', '', '{\"objectCode\":\"wxmaterial\"}', '', '0', ''), ('1063', 'messagemgr', '消息管理', 'single_grid', 'eova-icon306', '6', '1056', '1', '', '', '{\"objectCode\":\"mxmessage\"}', '', '0', ''), ('1064', 'usermgr', '关注管理', 'single_grid', 'eova-icon526', '1', '1056', '1', null, '', '{\"objectCode\":\"wxuser\"}', null, '0', null), ('1065', 'automessage', '自动回复', 'single_grid', 'eova-icon1006', '3', '1056', '1', null, '', '{\"objectCode\":\"wxkeyword\"}', null, '0', null), ('1066', 'menu_type', '自定义菜单类型', 'single_grid', 'eova-icon1166', '8', '1056', '1', '', '', '{\"objectCode\":\"wx_menutype\"}', '', '0', ''), ('1067', 'custom_menu', '自定义菜单', 'single_tree', 'eova-icon221', '7', '1056', '1', '', '', '{\"objectCode\":\"wx_custommenu\",\"tree\":{\"iconField\":\"\",\"idField\":\"id\",\"parentField\":\"pid\",\"rootPid\":\"0\",\"treeField\":\"name\"}}', '', '0', ''), ('1068', 'matchrule_menu', '个性自定义菜单', 'single_grid', 'eova-icon8', '8', '1056', '1', null, '', '{\"objectCode\":\"wx_matchrulemenu\"}', null, '0', null);
COMMIT;

-- ----------------------------
--  Table structure for `eova_object`
-- ----------------------------
DROP TABLE IF EXISTS `eova_object`;
CREATE TABLE `eova_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL COMMENT '对象编码',
  `name` varchar(100) NOT NULL COMMENT '对象名称',
  `view_name` varchar(255) DEFAULT NULL COMMENT '查询数据视图',
  `table_name` varchar(255) DEFAULT NULL COMMENT '保存数据主表',
  `pk_name` varchar(50) NOT NULL COMMENT '主键',
  `data_source` varchar(50) DEFAULT 'main' COMMENT '数据源',
  `is_single` tinyint(1) DEFAULT '1' COMMENT '是否单选',
  `is_celledit` tinyint(1) DEFAULT '0' COMMENT '是否可行内编辑',
  `is_show_num` tinyint(1) DEFAULT '1' COMMENT '是否显示行号',
  `is_first_load` tinyint(1) DEFAULT '1' COMMENT '是否初始加载',
  `filter` varchar(500) DEFAULT NULL COMMENT '初始数据过滤条件',
  `default_order` varchar(255) DEFAULT NULL COMMENT '默认排序字段(desc)',
  `diy_card` varchar(255) DEFAULT NULL COMMENT '自定义卡片面板',
  `diy_js` varchar(255) DEFAULT NULL COMMENT '依赖JS文件',
  `biz_intercept` varchar(255) DEFAULT NULL COMMENT '自定义业务拦截器',
  `view_sql` varchar(1000) DEFAULT NULL COMMENT '视图SQL',
  `config` varchar(2000) DEFAULT NULL COMMENT '拓展配置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=1149 DEFAULT CHARSET=utf8 COMMENT='EOVA元对象';

-- ----------------------------
--  Records of `eova_object`
-- ----------------------------
BEGIN;
INSERT INTO `eova_object` VALUES ('1', 'meta_template', '元对象模版数据', null, 'eova_template', 'id', 'eova', '1', '0', '1', '1', null, null, null, null, '', null, null), ('2', 'eova_menu_code', '菜单', '', 'eova_menu', 'id', 'eova', '0', '0', '1', '1', 'where parent_id <> 1 and id <> 1', '', null, '', 'com.eova.core.menu.MenuIntercept', null, ''), ('3', 'eova_object_code', '对象', '', 'eova_object', 'id', 'eova', '0', '0', '1', '1', 'where id > 999', 'id desc', null, '', 'com.eova.core.object.ObjectIntercept', null, ''), ('4', 'eova_field_code', '字段', '', 'eova_field', 'id', 'eova', '1', '1', '1', '1', '', 'fieldnum,order_num', null, '', '', null, null), ('5', 'eova_button_code', '按钮', '', 'eova_button', 'id', 'eova', '0', '0', '1', '1', 'where id > 999 and is_base = 0', 'id desc', null, '', '', null, ''), ('6', 'eova_user_code', '用户', '', 'eova_user', 'id', 'eova', '1', '0', '1', '1', 'where rid in (select id from eova_role where lv > ${user.role.lv})', 'id desc', null, '', 'com.eova.user.UserIntercept', null, ''), ('7', 'eova_role_code', '角色管理', '', 'eova_role', 'id', 'eova', '1', '0', '1', '1', '${user.role.lv} = 0 or ${user.role.lv} < lv', 'id desc', null, '', 'com.eova.core.role.RoleIntercept', null, null), ('8', 'eova_task_code', '定时调度', null, 'eova_task', 'id', 'eova', '1', '0', '1', '1', null, null, null, null, 'com.eova.core.task.TaskIntercept', null, null), ('9', 'eova_log_code', '操作日志', null, 'eova_log', 'id', 'eova', '1', '0', '1', '1', null, 'id desc', null, null, '', null, null), ('100', 'user_info_code', '用户详细信息', '', 'user_info', 'id', 'main', '1', '0', '1', '1', '', '', null, '/ui/js/diy/area.js', 'com.eova.user.UserInfoIntercept', null, null), ('1003', 'dicts', '业务字典', null, 'dicts', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1004', 'player_code', '玩家信息', null, 'users', 'id', 'main', '0', '0', '1', '1', '', 'id desc', null, '', '', null, null), ('1005', 'item_code', '道具', null, 'item', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1006', 'users_item_code', '艺人关联道具', '', 'users_item', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, null), ('1008', 'celledit_users_code', '可编辑用户', null, 'users', 'id', 'main', '1', '1', '1', '1', '', '', null, '', '', null, null), ('1009', 'users_exp_code', '艺人信息拓展', null, 'users_exp', 'users_id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, null), ('1010', 'hotel', '酒店', null, 'hotel', 'id', 'main', '1', '0', '1', '1', '', '', null, '/ui/js/diy/area.js', '', null, null), ('1011', 'order_item', '订单项', null, 'order_item', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1012', 'payment', '支付', null, 'payment', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1014', 'product', '产品', null, 'product', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, null), ('1015', 'hotel_bed', '酒店床位', '', 'hotel_bed', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, ''), ('1016', 'orders', '订单管理', null, 'orders', 'id', 'main', '1', '0', '1', '0', null, null, null, null, '', null, null), ('1017', 'hotel_stock', '酒店存货', null, 'hotel_stock', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1018', 'data_login', '每日登录用户统计', null, 'data_login', 'id', 'main', '1', '0', '1', '0', null, null, null, null, '', null, null), ('1053', 'test_info', 'EOVA全属性对象', null, 'test_info', 'id', 'main', '1', '0', '1', '1', null, null, null, null, 'com.oss.test.TestIntercept', null, null), ('1096', 'links', '友情链接', '', 'links', 'id', 'main', '1', '0', '1', '1', '', '', null, '/ui/js/diy/info/1.js', '', null, null), ('1098', 'data_money', '销售数据', null, 'data_money', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1110', 'v_orders', '订单管理', 'v_orders', '', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.oss.order.OrderIntercept', 'select `o`.`id` AS `id`,`o`.`state` AS `state`,`o`.`money` AS `money`,`o`.`memo` AS `memo`,`o`.`create_user_id` AS `create_user_id`,`o`.`create_time` AS `create_time`,`o`.`address_id` AS `address_id`,`a`.`name` AS `name`,`a`.`full` AS `full`,`a`.`mobilephone` AS `mobilephone`,`u`.`login_id` AS `login_id`,`u`.`nickname` AS `nickname`,`u`.`info` AS `info` from ((`demo`.`orders` `o` left join `demo`.`users` `u` on((`o`.`create_user_id` = `u`.`id`))) left join `demo`.`address` `a` on((`o`.`address_id` = `a`.`id`)))', '{\"view\":{\"address\":{\"paramField\":\"address_id\",\"whereField\":\"id\"},\"orders\":{\"paramField\":\"id\",\"whereField\":\"id\"},\"users\":{\"paramField\":\"create_user_id\",\"whereField\":\"id\"}}}'), ('1119', 'v_users', '用户视图', 'v_userinfo', '', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', 'select `u`.`id` AS `id`,`u`.`status` AS `status`,`u`.`login_id` AS `login_id`,`u`.`login_pwd` AS `login_pwd`,`u`.`nickname` AS `nickname`,`u`.`reg_time` AS `reg_time`,`u`.`info` AS `info`,`u`.`tag` AS `tag`,`ue`.`exp` AS `exp`,`ue`.`avg` AS `avg`,`ue`.`qq` AS `qq` from `demo`.`users` `u` join `demo`.`users_exp` `ue` where (`u`.`id` = `ue`.`users_id`)', '{\"view\":{\"users\":{\"whereField\":\"id\",\"paramField\":\"id\"},\"users_exp\":{\"whereField\":\"users_id\",\"paramField\":\"id\"}}}'), ('1122', 'area', '省市区', '', 'area', 'id', 'main', '1', '0', '1', '1', 'lv < 3', '', null, '', '', null, ''), ('1123', 'area_city', '全国各省', '', 'area_city', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, null), ('1124', 'sale_data', '销售数据', null, 'sale_data', 'id', 'main', '1', '0', '1', '1', null, null, null, null, '', null, null), ('1134', 'wxuser', '微信用户', null, 'wx_user', 'id', 'main', '1', '0', '1', '1', null, null, null, null, null, null, null), ('1137', 'mxmessage', '微信消息', null, 'wx_message', 'id', 'main', '1', '0', '1', '1', null, null, null, null, null, null, null), ('1138', 'wxsubmgs', '关注回复', '', 'wx_submsg', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.AppIdIntercept', null, ''), ('1139', 'wxadmin', '登录用户', '', 'wx_admin', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.AdminUserIntercept', null, ''), ('1140', 'wxconfig', '微信配置', '', 'wx_config', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.WxConfigIntercept', null, ''), ('1141', 'wxmaterial', '素材管理', '', 'wx_material', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.AppIdIntercept', null, ''), ('1143', 'wxkeyword', '关键字回复', '', 'wx_keyword', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.AppIdIntercept', null, ''), ('1144', 'wx_menutype', '自定义菜单类型', '', 'wx_menutype', 'id', 'main', '1', '0', '1', '1', '', '', null, '', '', null, ''), ('1145', 'wx_custommenu', '自定义菜单', '', 'wx_custommenu', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.WxMenuIntercept', null, ''), ('1148', 'wx_matchrulemenu', '个性化菜单', '', 'wx_matchrulemenu', 'id', 'main', '1', '0', '1', '1', '', '', null, '', 'com.javen.wx.intercept.AppIdIntercept', null, '');
COMMIT;

-- ----------------------------
--  Table structure for `eova_role`
-- ----------------------------
DROP TABLE IF EXISTS `eova_role`;
CREATE TABLE `eova_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '角色名',
  `info` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `lv` int(11) DEFAULT '0' COMMENT '权限级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='EOVA角色';

-- ----------------------------
--  Records of `eova_role`
-- ----------------------------
BEGIN;
INSERT INTO `eova_role` VALUES ('1', '超级管理员', '开发者权限(禁止作为业务权限)', '0'), ('2', '管理员', '管理所有可用功能', '10'), ('3', '测试组长', '测试小组的组长', '20'), ('4', '测试通用', '测试通用权限', '30'), ('5', '普通用户', '普通用户', '40');
COMMIT;

-- ----------------------------
--  Table structure for `eova_role_btn`
-- ----------------------------
DROP TABLE IF EXISTS `eova_role_btn`;
CREATE TABLE `eova_role_btn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL COMMENT '角色',
  `bid` int(11) NOT NULL COMMENT '功能',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=459 DEFAULT CHARSET=utf8 COMMENT='EOVA角色按钮';

-- ----------------------------
--  Records of `eova_role_btn`
-- ----------------------------
BEGIN;
INSERT INTO `eova_role_btn` VALUES ('1', '1', '1003'), ('2', '1', '1004'), ('3', '1', '1001'), ('4', '1', '1002'), ('5', '1', '1008'), ('6', '1', '1005'), ('7', '1', '1108'), ('8', '1', '1091'), ('9', '1', '1006'), ('10', '1', '1109'), ('11', '1', '1106'), ('12', '1', '1093'), ('13', '1', '1107'), ('14', '1', '1092'), ('15', '1', '1104'), ('16', '1', '1009'), ('17', '1', '1095'), ('18', '1', '1105'), ('19', '1', '1094'), ('20', '1', '1097'), ('21', '1', '1103'), ('22', '1', '1099'), ('23', '1', '1100'), ('24', '1', '1098'), ('25', '1', '1101'), ('26', '1', '1089'), ('27', '1', '1110'), ('28', '1', '43'), ('29', '1', '42'), ('30', '1', '41'), ('31', '1', '40'), ('32', '1', '1011'), ('33', '1', '1010'), ('34', '1', '1080'), ('35', '1', '22'), ('36', '1', '1084'), ('37', '1', '23'), ('38', '1', '1082'), ('39', '1', '25'), ('40', '1', '1081'), ('41', '1', '26'), ('42', '1', '1088'), ('43', '1', '27'), ('44', '1', '1087'), ('45', '1', '28'), ('46', '1', '1086'), ('47', '1', '29'), ('48', '1', '1085'), ('49', '1', '3'), ('50', '1', '1'), ('51', '1', '1078'), ('52', '1', '1079'), ('53', '1', '30'), ('54', '1', '7'), ('55', '1', '6'), ('56', '1', '32'), ('57', '1', '31'), ('58', '1', '4'), ('59', '1', '9'), ('60', '1', '8'), ('61', '1', '1000'), ('62', '1', '1075'), ('63', '1', '1124'), ('64', '1', '1074'), ('65', '1', '1125'), ('66', '1', '1077'), ('67', '1', '1122'), ('68', '1', '1123'), ('69', '1', '1071'), ('70', '1', '1070'), ('71', '1', '1073'), ('72', '1', '1126'), ('73', '1', '1072'), ('74', '1', '1127'), ('75', '1', '20'), ('76', '1', '1067'), ('77', '1', '1068'), ('78', '1', '100'), ('79', '1', '1119'), ('80', '1', '90'), ('81', '1', '1111'), ('82', '1', '1066'), ('83', '1', '1112'), ('84', '1', '1065'), ('85', '1', '1113'), ('86', '1', '1064'), ('87', '1', '1063'), ('88', '1', '1115'), ('89', '1', '1061'), ('90', '1', '1116'), ('91', '1', '1060'), ('92', '1', '1117'), ('93', '1', '1118'), ('94', '1', '1058'), ('95', '1', '1059'), ('96', '1', '1056'), ('97', '1', '1057'), ('98', '1', '1120'), ('99', '1', '88'), ('100', '1', '116'), ('101', '1', '112'), ('102', '1', '113'), ('103', '1', '110'), ('104', '1', '111'), ('105', '1', '1049'), ('106', '1', '1050'), ('107', '1', '1051'), ('108', '1', '1054'), ('109', '1', '1052'), ('110', '1', '1053'), ('111', '1', '82'), ('112', '1', '83'), ('113', '1', '80'), ('114', '1', '81'), ('115', '1', '86'), ('116', '1', '87'), ('117', '1', '84'), ('118', '1', '127'), ('119', '1', '121'), ('120', '1', '122'), ('121', '1', '123'), ('122', '1', '124'), ('123', '1', '1035'), ('124', '1', '1034'), ('125', '1', '1037'), ('126', '1', '1036'), ('127', '1', '129'), ('128', '1', '1039'), ('129', '1', '1038'), ('130', '1', '1040'), ('131', '1', '1041'), ('132', '1', '1029'), ('133', '1', '1027'), ('134', '1', '1026'), ('135', '1', '1025'), ('136', '1', '1024'), ('137', '1', '1023'), ('138', '1', '1032'), ('139', '1', '1033'), ('140', '1', '1030'), ('141', '1', '1031'), ('142', '1', '45'), ('143', '1', '44'), ('144', '1', '1017'), ('145', '1', '1016'), ('146', '1', '1019'), ('147', '1', '1018'), ('148', '1', '1013'), ('149', '1', '1012'), ('150', '1', '1015'), ('151', '1', '1020'), ('152', '1', '1022'), ('153', '2', '1003'), ('154', '2', '1004'), ('155', '2', '1001'), ('156', '2', '1002'), ('157', '2', '1008'), ('158', '2', '1005'), ('159', '2', '1108'), ('160', '2', '1091'), ('161', '2', '1006'), ('162', '2', '1109'), ('163', '2', '1106'), ('164', '2', '1093'), ('165', '2', '1107'), ('166', '2', '1092'), ('167', '2', '1104'), ('168', '2', '1009'), ('169', '2', '1095'), ('170', '2', '1105'), ('171', '2', '1094'), ('172', '2', '1097'), ('173', '2', '1103'), ('174', '2', '1099'), ('175', '2', '1100'), ('176', '2', '1098'), ('177', '2', '1101'), ('178', '2', '1089'), ('179', '2', '1110'), ('180', '2', '1011'), ('181', '2', '1010'), ('182', '2', '1080'), ('183', '2', '1084'), ('184', '2', '1082'), ('185', '2', '1081'), ('186', '2', '1088'), ('187', '2', '1087'), ('188', '2', '1086'), ('189', '2', '1085'), ('190', '2', '1078'), ('191', '2', '1079'), ('192', '2', '1000'), ('193', '2', '1075'), ('194', '2', '1124'), ('195', '2', '1074'), ('196', '2', '1125'), ('197', '2', '1077'), ('198', '2', '1122'), ('199', '2', '1123'), ('200', '2', '1071'), ('201', '2', '1070'), ('202', '2', '1073'), ('203', '2', '1126'), ('204', '2', '1072'), ('205', '2', '1127'), ('206', '2', '1067'), ('207', '2', '1068'), ('208', '2', '100'), ('209', '2', '1119'), ('210', '2', '1111'), ('211', '2', '1066'), ('212', '2', '1112'), ('213', '2', '1065'), ('214', '2', '1113'), ('215', '2', '1064'), ('216', '2', '1063'), ('217', '2', '1115'), ('218', '2', '1061'), ('219', '2', '1116'), ('220', '2', '1060'), ('221', '2', '1117'), ('222', '2', '1118'), ('223', '2', '1058'), ('224', '2', '1059'), ('225', '2', '1056'), ('226', '2', '1057'), ('227', '2', '1120'), ('228', '2', '116'), ('229', '2', '112'), ('230', '2', '113'), ('231', '2', '110'), ('232', '2', '111'), ('233', '2', '1049'), ('234', '2', '1050'), ('235', '2', '1051'), ('236', '2', '1054'), ('237', '2', '1052'), ('238', '2', '1053'), ('239', '2', '127'), ('240', '2', '121'), ('241', '2', '122'), ('242', '2', '123'), ('243', '2', '124'), ('244', '2', '1035'), ('245', '2', '1034'), ('246', '2', '1037'), ('247', '2', '1036'), ('248', '2', '129'), ('249', '2', '1039'), ('250', '2', '1038'), ('251', '2', '1040'), ('252', '2', '1041'), ('253', '2', '1029'), ('254', '2', '1027'), ('255', '2', '1026'), ('256', '2', '1025'), ('257', '2', '1024'), ('258', '2', '1023'), ('259', '2', '1032'), ('260', '2', '1033'), ('261', '2', '1030'), ('262', '2', '1031'), ('263', '2', '1017'), ('264', '2', '1016'), ('265', '2', '1019'), ('266', '2', '1018'), ('267', '2', '1013'), ('268', '2', '1012'), ('269', '2', '1015'), ('270', '2', '1020'), ('271', '2', '1022'), ('282', '3', '1070'), ('283', '3', '1049'), ('284', '1', '1129'), ('285', '1', '1130'), ('286', '1', '1131'), ('287', '1', '1132'), ('288', '1', '1133'), ('289', '1', '1134'), ('290', '1', '1135'), ('291', '1', '1136'), ('292', '1', '1137'), ('293', '1', '1138'), ('294', '1', '1139'), ('295', '1', '1140'), ('296', '1', '1141'), ('297', '1', '1142'), ('298', '1', '1143'), ('299', '1', '1144'), ('316', '1', '1145'), ('317', '1', '1146'), ('318', '1', '1147'), ('319', '1', '1148'), ('320', '1', '1149'), ('321', '1', '1150'), ('322', '1', '1151'), ('323', '1', '1152'), ('324', '1', '1153'), ('325', '1', '1154'), ('326', '1', '1155'), ('327', '1', '1156'), ('328', '1', '1157'), ('329', '1', '1158'), ('330', '1', '1159'), ('349', '1', '1160'), ('350', '1', '1161'), ('351', '1', '1162'), ('352', '1', '1163'), ('353', '1', '1164'), ('354', '1', '1165'), ('355', '1', '1166'), ('356', '1', '1167'), ('357', '1', '1168'), ('358', '1', '1169'), ('359', '1', '1170'), ('360', '1', '1171'), ('361', '1', '1172'), ('362', '1', '1173'), ('363', '1', '1174'), ('364', '1', '1175'), ('365', '1', '1176'), ('366', '1', '1177'), ('367', '1', '1178'), ('368', '1', '1179'), ('369', '1', '1180'), ('370', '1', '1181'), ('371', '1', '1182'), ('372', '1', '1183'), ('373', '1', '1184'), ('374', '1', '1185'), ('375', '1', '1186'), ('376', '1', '1187'), ('377', '1', '1188'), ('378', '1', '1189'), ('379', '1', '1190'), ('380', '1', '1191'), ('381', '1', '1192'), ('382', '1', '1193'), ('383', '1', '1194'), ('384', '1', '1195'), ('385', '1', '1196'), ('386', '1', '1197'), ('387', '1', '1198'), ('388', '1', '1199'), ('389', '1', '1200'), ('424', '5', '1143'), ('425', '5', '1142'), ('426', '5', '1164'), ('427', '5', '1141'), ('428', '5', '1163'), ('429', '5', '1185'), ('430', '5', '1140'), ('431', '5', '1162'), ('432', '5', '1161'), ('433', '5', '1160'), ('434', '5', '1181'), ('435', '5', '1139'), ('436', '5', '1138'), ('437', '5', '1135'), ('438', '5', '1157'), ('439', '5', '1156'), ('440', '5', '1155'), ('441', '5', '1190'), ('442', '5', '1154'), ('443', '5', '1198'), ('444', '5', '1131'), ('445', '5', '1153'), ('446', '5', '1197'), ('447', '5', '1196'), ('448', '5', '1195'), ('449', '5', '1150'), ('450', '5', '1194'), ('451', '5', '1192'), ('452', '5', '1191'), ('453', '5', '1149'), ('454', '5', '1148'), ('455', '5', '1147'), ('456', '5', '1146'), ('457', '5', '1189'), ('458', '5', '1188');
COMMIT;

-- ----------------------------
--  Table structure for `eova_task`
-- ----------------------------
DROP TABLE IF EXISTS `eova_task`;
CREATE TABLE `eova_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` int(1) NOT NULL DEFAULT '0' COMMENT '状态：0=停止，1=启动',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `exp` varchar(50) NOT NULL COMMENT '表达式',
  `clazz` varchar(255) NOT NULL COMMENT '实现类',
  `info` varchar(255) DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='EOVA任务';

-- ----------------------------
--  Records of `eova_task`
-- ----------------------------
BEGIN;
INSERT INTO `eova_task` VALUES ('1', '0', '每分', '0 0/1 * * * ?', 'com.oss.job.EveryMinJob', '每分钟来一发'), ('2', '0', '每时', '0 0 0/1 * * ?', 'com.oss.job.EveryHourJob', '每小时统计一次'), ('12', '0', '每天', '59 59 23 * * ?', 'com.oss.job.EveryDayJob', '每天23点59分59秒跑一下');
COMMIT;

-- ----------------------------
--  Table structure for `eova_user`
-- ----------------------------
DROP TABLE IF EXISTS `eova_user`;
CREATE TABLE `eova_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_id` varchar(30) NOT NULL COMMENT '帐号',
  `login_pwd` varchar(50) NOT NULL COMMENT '密码',
  `rid` int(11) DEFAULT '0' COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='EOVA用户';

-- ----------------------------
--  Records of `eova_user`
-- ----------------------------
BEGIN;
INSERT INTO `eova_user` VALUES ('1', 'eova', '89BDF69372C2EF53EA409CDF020B5694', '1'), ('2', 'admin', '89BDF69372C2EF53EA409CDF020B5694', '2'), ('3', 'test', '89BDF69372C2EF53EA409CDF020B5694', '3'), ('4', 'test1', '89BDF69372C2EF53EA409CDF020B5694', '4'), ('5', 'test001', 'BE88DFE624999638495B304548570AEB', '2'), ('7', 'test001', 'BE88DFE624999638495B304548570AEB', '2');
COMMIT;

-- ----------------------------
--  Table structure for `eova_widget`
-- ----------------------------
DROP TABLE IF EXISTS `eova_widget`;
CREATE TABLE `eova_widget` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(5) NOT NULL DEFAULT '1' COMMENT '控件类型：1=EOVA控件，2=DIY控件',
  `value` varchar(50) NOT NULL COMMENT '控件值',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `version` float(5,1) DEFAULT '1.0' COMMENT '版本号',
  `path` varchar(50) DEFAULT NULL COMMENT '路径',
  `description` varchar(4000) DEFAULT NULL COMMENT '介绍',
  `config` varchar(4000) DEFAULT NULL COMMENT '控件配置信息JSON',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='EOVA插件';

-- ----------------------------
--  Records of `eova_widget`
-- ----------------------------
BEGIN;
INSERT INTO `eova_widget` VALUES ('1', '1', '下拉框', '下拉框', '1.0', '', '', null), ('2', '1', '查找框', '查找框', '1.0', '', '', null), ('3', '1', '文本框', '文本框', '1.0', '', '', null), ('4', '1', '文本域', '文本域', '1.0', '', '', null), ('5', '1', '编辑框', '编辑框', '1.0', '', '', null), ('6', '1', 'JSON框', 'JSON框', '1.0', '', '', null), ('7', '1', '时间框', '时间框', '1.0', '', '', null), ('8', '1', '日期框', '日期框', '1.0', '', '', null), ('9', '1', '布尔框', '布尔框', '1.0', '', '', null), ('10', '1', '图片框', '图片框', '1.0', '', '', null), ('11', '1', '文件框', '文件框', '1.0', '', '', null), ('12', '1', '图标框', '图标框', '1.0', '', '', null), ('13', '1', '自增框', '自增框', '1.0', '', '', null), ('30', '2', '密码框', '密码框', '1.0', '/widget/password/index.html', '我的密码框，系统不给，自己造一个，大家一起爽歪歪', null), ('31', '2', '数字框', '数字框', '1.0', '/widget/number/index.html', 'number', null), ('32', '2', '颜色框', '颜色框', '1.0', '/widget/color/index.html', 'color', null), ('33', '2', '复选框', '复选框', '1.0', '/widget/check/index.html', '下拉变多复选框', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
